COMM_SCTN_DATA

(SQL Table)
 Index Back

Communication Section Hdr Data

COMM_SCTN_DATA is the second table of two which contains the letter printed data. The letter printed data is all of the information which was output (currently either to JetForm or Word) for this communication. The actual letter itself determines what data was utilized. This record contains the specific output Section Header Data from the output file.

  • Parent record: COMM_SCTN_HDR

    • # 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 COMM_SECTION_HDR Character(4) VARCHAR2(4) NOT NULL Communication Section Header
    ADMN=Admin Function
    CKLI=Checklist Items
    COMM=Communication Data
    NMAD=Name and Address
    PRDT=Personal Data
    UNIQ=Unique Data
    4 COMM_FIELD_NBR Number(4,0) SMALLINT NOT NULL Communication Field Nbr
    5 RECNAME Character(15) VARCHAR2(15) NOT NULL Record (Table) Name (see PSRECDEFN).
    6 FIELDNAME Character(18) VARCHAR2(18) NOT NULL Field Name (see PSDBFIELD).
    7 FIELD_SOURCE Character(15) VARCHAR2(15) NOT NULL Field Source
    8 COMM_FIELD_NAME Character(18) VARCHAR2(18) NOT NULL Communication Field Name
    9 COMM_TAG_NAME Character(20) VARCHAR2(20) NOT NULL Communication Tag Name
    10 COMM_FIELD_VALUE Character(80) VARCHAR2(80) NOT NULL Communication Field Value