GPCH_EG_DSET

(SQL Table)
Index Back

Domain Set Setup

GPCH:ELM Domain Set Setup

  • Related Language Record: GPCH_EG_DM_LANG
  • # 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