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 | 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 |