SWFOGRC

Sewer FOG Receiving Facility Contacts

Field Name

Caption

Mask

Description

Field Type

RC_COMMENT

Short Comment

254x

Short Comment

Text

RC_CONT_CD

Contact Type

nnn

Contact Type

Integer

RC_CONT_TY

Contact Type Text

30x

Contact Type Text

Text

RC_CRT_BY

Created By

25x

Created By

Text

RC_CRT_DTTM

Creation Date Time

mm/dd/yyyy hh:mm am

Creation Date Time

Date/Time

RC_DOC_FLG

Document Available

 

Document Flag

Boolean

RC_EMAIL

Email

150x

Email

Text

RC_EPHONE

Emergency Phone

25x

Emergency Phone

Text

RC_FAX

Fax Phone

25x

Fax

Text

RC_ID

Receiver Contact Rec #

nnnnnnnn

Receiving Station Contact Record Number

Long Integer

RC_MOBILE

Cell Phone

25x

Mobile/Cell Phone

Text

RC_MOD_BY

Last Mod By

25x

Last Modified By

Text

RC_MOD_DT

Last Mod Date

mm/dd/yyyy

Last Modified Date

Date/Time

RC_MOD_TM

Last Modified Time

hh:mm am

Modified Time

Date/Time

RC_NAME

Name

50x

Name

Text

RC_PHONE

Phone

25x

Phone

Text

RC_ROWVER

 

 

Rowversion for optimistic locking

Date/Time

RC_RV_ID

Receive Record No

nnnnnnnn

Link to SWFOGR.RV_ID

Long Integer

RC_TITL_CD

Title

nnn

Title

Integer

RC_TITL_TY

Title Text

30x

Title Text

Text