SWFOGFD

Sewer FOG Disposal to Receiving Station

Field Name

Caption

Mask

Description

Field Type

FD_ACOLL

Amount Collected

nnnnn

Amount Collected from Facilities on Manifest

Integer

FD_COC

Chain of Custody

 

Chain of Custody

Boolean

FD_COMMENT

Short Comment

254x

Short Comment

Text

FD_CRT_BY

Created By

25x

Created By

Text

FD_CRT_DTTM

Creation Date Time

mm/dd/yyyy hh:mm am

Creation Date Time

Date/Time

FD_DISP_DT

Disposal Date

mm/dd/yyyy

Disposal Date

Date/Time

FD_DISP_TM

Disposal Time

hh:mm am

Disposal Time

Date/Time

FD_DISPA

Disposal Amount

nnnnn

Disposal Amount

Integer

FD_DOC_FLG

Document Available

 

Document Flag

Boolean

FD_DRNAME

Driver Name

50x

Driver Name

Text

FD_FEE

Disposal Fee

nnnnnnnn.nn

Disposal Fee

Double

FD_HA_ID

Hauler Record No

nnnnnnnn

Link to SWFOGH.HA_ID

Long Integer

FD_HNAME

Hauler Name

50x

Hauler Name

Text

FD_HNUMBER

Hauler Number

30x

Hauler Number

Text

FD_ID

Disposal Record No

nnnnnnnn

Disposal Rec #

Long Integer

FD_MANIF

Manifest #

30x

Mainifest

Text

FD_MOD_BY

Last Mod By

25x

Last Modified By

Text

FD_MOD_DT

Last Mod Date

mm/dd/yyyy

Last Modified Date

Date/Time

FD_MOD_TM

Last Modified Time

hh:mm am

Modified Time

Date/Time

FD_OPNAME

Operator Name

50x

Facility Operator Name

Text

FD_PH

Sample pH

nnnnnnnn.n

pH from Sample

Double

FD_RNAME

Rec Station Name

50x

Receiving Station Name

Text

FD_RNUMBER

Rec Station Number

30x

Receiving Station Number

Text

FD_ROWVER

 

 

Rowversion for optimistic locking

Date/Time

FD_RV_ID

Rec Station Record No

nnnnnnnn

Link to SWFOGR.RV_ID

Long Integer

FD_SAMPLNO

Sample Number

20x

Sampling Number

Text

FD_SMPL_CD

Sample Results

nnn

Sample Results

Integer

FD_SMPL_TY

Sample Results Text

30x

Sample Results Text

Text

FD_TYPE_CD

Waste Type

nnn

Waste Type

Integer

FD_TYPE_TY

Waste Type Text

30x

Waste Type Text

Text

FD_UNITFEE

Unit Disposal Fee

nnnnnnnn.n

Unit Disposal Fee

Double

FD_UOM_CD

UOM

nnn

UOM

Integer

FD_UOM_TY

UOM Text

30x

UOM Text

Text

FD_USER10

User 10

30x

User 10

Text

FD_USER11

User 11

nnnnnnnn.nn

User 11

Double

FD_USER12

User 12

nnnnnnnn.nn

User 12

Double

FD_USER13

User 13

nnnnnnnn.nn

User 13

Double

FD_USER14

User 14

nnnnnnnn.nn

User 14

Double

FD_USER15

User 15

nnnnnnnn.nn

User 15

Double

FD_USER16

User 16

mm/dd/yyyy

User 16

Date/Time

FD_USER17

User 17

mm/dd/yyyy

User 17

Date/Time

FD_USER18

User 18

mm/dd/yyyy

User 18

Date/Time

FD_USER19

User 19

mm/dd/yyyy

User 19

Date/Time

FD_USER1CD

User 1

nnn

User 1

Integer

FD_USER1TY

User 1 Text

30x

User 1 Text

Text

FD_USER20

User 20

mm/dd/yyyy

User 20

Date/Time

FD_USER21

User 21

 

User 21

Boolean

FD_USER22

User 22

 

User 22

Boolean

FD_USER23

User 23

 

User 23

Boolean

FD_USER24

User 24

 

User 24

Boolean

FD_USER25

User 25

 

User 25

Boolean

FD_USER2CD

User 2

nnn

User 2

Integer

FD_USER2TY

User 2 Text

30x

User 2 Text

Text

FD_USER3CD

User 3

nnn

User 3

Integer

FD_USER3TY

User 3 Text

30x

User 3 Text

Text

FD_USER4CD

User 4

nnn

User 4

Integer

FD_USER4TY

User 4 Text

30x

User 4 Text

Text

FD_USER5CD

User 5

nnn

User 5

Integer

FD_USER5TY

User 5 Text

30x

User 5 Text

Text

FD_USER6

User 6

30x

User 6

Text

FD_USER7

User 7

30x

User 7

Text

FD_USER8

User 8

30x

User 8

Text

FD_USER9

User 9

30x

User 9

Text

FD_VEHICL

Vehicle Number

20x

Vehicle Number

Text