SCC_CGR_ATTREL

(SQL Table)
Index Back

CommGen Recipient File Table

CommGen Recipient File Table stores a relationship between the recipient letter code and the output xml extract file generated for each Person communication row.

  • Parent record: COMM_RECIPIENTS
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 COMMON_ID Character(11) VARCHAR2(11) NOT NULL Common ID to store Personal ID / Ext Org ID value
    2 SEQ_3C Number(5,0) INTEGER NOT NULL Sequence Number
    3 RELATIONSHIP_NBR Number(2,0) SMALLINT NOT NULL Relationship Nbr
    4 ENCL_SEQ_NUM Number(3,0) SMALLINT NOT NULL Sequence Number
    5 ATTACHSYSFILENAME Character(128) VARCHAR2(128) NOT NULL Unique Sys Filename
    6 ATTACHUSERFILE Character(64) VARCHAR2(64) NOT NULL Attached File
    7 REPORT_DEFN_ID Character(12) VARCHAR2(12) NOT NULL Report Name (see PSXPRPTDEFN).
    8 TMPLDEFN_ID Character(30) VARCHAR2(30) NOT NULL Template ID (see PSXPTMPLDEFN).
    9 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    10 ASOFDATE Date(10) DATE As of Date
    11 PT_FORMAT_TYPE Character(3) VARCHAR2(3) NOT NULL Format Type
    HTM=HTML
    PDF=PDF
    RTF=RTF
    TXT=TXT
    XLS=XLS
    12 SCC_LETTER_CD Character(3) VARCHAR2(3) NOT NULL Letter Code