GPCH_EG_DSET(SQL Table) |
Index Back |
|---|---|
Domain Set SetupGPCH:ELM Domain Set Setup |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | Character(3) | VARCHAR2(3) NOT NULL |
Company
Prompt Table: COMPANY_TBL |
|
| 2 | Number(3,0) | SMALLINT NOT NULL |
Domain Set ID for the ELM Domain Sets
Default Value: 1 |
|
| 3 | Date(10) | DATE NOT NULL |
Effective Date
Default Value: %date |
|
| 4 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 5 | GPCH_EG_NAME | Character(30) | VARCHAR2(30) NOT NULL | Name of Contact Person for the ELM file |
| 6 | EMAILID | Character(70) | VARCHAR2(70) NOT NULL | A user's E-mail address |
| 7 | PHONE | Character(24) | VARCHAR2(24) NOT NULL | Telephone |
| 8 | FILE_OUTPUT_DIR | Character(127) | VARCHAR2(127) NOT NULL | Output Directory Name for Flat File Interfaces. |
| 9 | GPCH_EG_CREATE | Character(1) | VARCHAR2(1) NOT NULL |
Create File Flag
Y/N Table Edit Default Value: N |
| 10 | GPCH_EG_VALIDATE | Character(1) | VARCHAR2(1) NOT NULL |
Flag to specify if the ELM File needs to be validated
Y/N Table Edit Default Value: N |
| 11 | GPCH_EG_ENCRYPT | Character(1) | VARCHAR2(1) NOT NULL |
Flag for ELM File Encryption
Y/N Table Edit Default Value: N |
| 12 | GPCH_EG_SIGN | Character(1) | VARCHAR2(1) NOT NULL |
Flag to specify if the ELM file has to be signed.
Y/N Table Edit Default Value: N |
| 13 | GPCH_EG_COMPRESS | Character(1) | VARCHAR2(1) NOT NULL |
Flag to specify Compression of ELM File
Y/N Table Edit Default Value: N |
| 14 | GPCH_EG_MONITOR_ID | Character(25) | VARCHAR2(25) NOT NULL | Holds Moniter ID in the ELM File |
| 15 | COMMENTS | Long Character | CLOB | Comment |
| 16 | LEGAL_REP | Character(1) | VARCHAR2(1) NOT NULL |
Legal Representative
Y/N Table Edit Default Value: N |