COMM_SCTN_HDR(SQL Table) |
Index Back |
---|---|
Communication Section HeaderCOMM_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. |
# | 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 |