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 | COMPANY | Character(3) | VARCHAR2(3) NOT NULL |
Company
Prompt Table: COMPANY_TBL |
2 | GPCH_EG_DOMAINID | Number(3,0) | SMALLINT NOT NULL |
Domain Set ID for the ELM Domain Sets
Default Value: 1 |
3 | EFFDT | 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 |
17 | GPCH_EG_VERSION | Character(4) | VARCHAR2(4) NOT NULL |
Swissdec Version Number
2=Version 4.0 5=Version 5.0 Default Value: 2 |