GPCH_EG_ST_HDR(SQL Table) |
Index Back |
|---|---|
ELM Status Header recordGPCH ELM : Status Header |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | Character(3) | VARCHAR2(3) NOT NULL | Company | |
| 2 | Number(3,0) | SMALLINT NOT NULL | Domain Set ID for the ELM Domain Sets | |
| 3 | 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 |