COMM_SCTN_HDR

(SQL Table)
Index Back

Communication Section Header

COMM_SCTN_HDR is the first 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 output Section Header information for viewing/grouping purposes.

  • Parent record: COMMUNICATION
  • # 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