GPCH_EG_ST_HDR

(SQL Table)
Index Back

ELM Status Header record

GPCH ELM : Status Header

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 COMPANY Character(3) VARCHAR2(3) NOT NULL Company
2 GPCH_EG_DOMAINID Number(3,0) SMALLINT NOT NULL Domain Set ID for the ELM Domain Sets
3 GPCH_RC_PAY_YEAR Number(4,0) SMALLINT NOT NULL Pay Year
4 GPCH_EG_CREATE Character(1) VARCHAR2(1) NOT NULL Create File Flag

Default Value: N

5 GPCH_EG_VALIDATE Character(1) VARCHAR2(1) NOT NULL Flag to specify if the ELM File needs to be validated

Default Value: N

6 GPCH_EG_SIGN Character(1) VARCHAR2(1) NOT NULL Flag to specify if the ELM file has to be signed.

Default Value: N

7 GPCH_EG_ENCRYPT Character(1) VARCHAR2(1) NOT NULL Flag for ELM File Encryption

Default Value: N

8 GPCH_EG_COMPRESS Character(1) VARCHAR2(1) NOT NULL Flag to specify Compression of ELM File

Default Value: N

9 GPCH_EG_NAME Character(30) VARCHAR2(30) NOT NULL Name of Contact Person for the ELM file
10 EMAILID Character(70) VARCHAR2(70) NOT NULL A user's E-mail address
11 PHONE Character(24) VARCHAR2(24) NOT NULL Telephone
12 FILE_OUTPUT_DIR Character(127) VARCHAR2(127) NOT NULL Output Directory Name for Flat File Interfaces.
13 COMMENTS Long Character CLOB Comment
14 GPCH_EG_MONITOR_ID Character(25) VARCHAR2(25) NOT NULL Holds Moniter ID in the ELM File
15 DATETIME_STAMP DateTime(26) TIMESTAMP DateTime Stamp