SCC_CG_GEN_DTA

(SQL Table)
 Index Back

CommGen Generic Data Source

SYSTEM DATA - CommGen Generic Data Source Table stores the record name and Critical Data indicator of the record to be included in the XML Publisher Data Source.

  • Parent record: SCC_CG_DTASRC

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SCC_CG_DS_ID Number(5,0) INTEGER NOT NULL CommGen Sequence Number as high level key of CommGen Data Source definition.
    2 SEQNO Number(5,0) INTEGER NOT NULL Sequence Number
    3 CG_GENDTA_TYPE Character(3) VARCHAR2(3) NOT NULL CommGen generic data type
    ADR=Address
    CHK=Checklist Items
    EML=Email Address
    ENC=Enclosures
    NAD=Address Name
    NEX=Extra Name
    NJT=Joint Salutation Name
    NLD=Netherlands Name
    NSA=Salutation Name
    ORA=Org Recipient Address
    ORE=Org Recipient Email
    ORN=Org Recipient Name
    RCP=Recipient List
    4 SCC_CG_GEN_DTA Character(15) VARCHAR2(15) NOT NULL CommGen Generic Data key field.
    5 SCC_CG_RQD_DTA Character(1) VARCHAR2(1) NOT NULL CommGen Critical Data required flag

    Y/N Table Edit