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  |