COMMON_IDSEQ_3CCG_SEQSCC_LETTER_CDO=Organization
P=Person
SCC_CG_HDR_VW(SQL View) |
Index Back |
|---|---|
CommGen Header ViewThis view acts as the header record for constructing the CommGen Data Source. It's not actually used by the CommGen process anymore after the Concurrency changes. |
| SELECT A.COMMON_ID , A.SEQ_3C , B.CG_SEQ , B.SCC_LETTER_CD , B.CG_SORT_ORDER , B.TMPLDEFN_ID , B.LANGUAGE_CD , A.SA_ID_TYPE , A.VAR_DATA_SEQ , A.INSTITUTION , A.EMPLID_RELATED , A.JOINT_COMM , A.INCLUDE_ENCL , 0 , 'N' , B.RELATIONSHIP_NBR , 0 , 0 , 0 , A.COMM_DTTM , A.COMM_DT , %CurrentDateIn , A.COMMENT_PRINT_FLAG , B.PROCESS_INSTANCE , A.COMM_COMMENTS FROM %Table(COMMUNICATION) A , %Table(SCC_CG_MERG_TBL) B WHERE A.COMMON_ID = B.COMMON_ID AND A.SEQ_3C = B.SEQ_3C |
| # | 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 | CG_SEQ |
Number(5,0) | INTEGER NOT NULL | CommGen Sequence |
| 4 | SCC_LETTER_CD |
Character(3) | VARCHAR2(3) NOT NULL | Letter Code |
| 5 | CG_SORT_ORDER | Number(5,0) | INTEGER NOT NULL | Sort Order |
| 6 | TMPLDEFN_ID | Character(30) | VARCHAR2(30) NOT NULL | Template ID (see PSXPTMPLDEFN). |
| 7 | LANGUAGE_CD | Character(3) | VARCHAR2(3) NOT NULL | Language Code |
| 8 | SA_ID_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
ID Type
O=Organization P=Person |
| 9 | VAR_DATA_SEQ | Number(4,0) | SMALLINT NOT NULL | Variable Data Sequence Number |
| 10 | INSTITUTION | Character(5) | VARCHAR2(5) NOT NULL | Academic Institution |
| 11 | EMPLID_RELATED | Character(11) | VARCHAR2(11) NOT NULL | Related People ID |
| 12 | JOINT_COMM | Character(1) | VARCHAR2(1) NOT NULL | Create Joint Communications |
| 13 | INCLUDE_ENCL | Character(1) | VARCHAR2(1) NOT NULL | Include Enclosures |
| 14 | ENCL_SEQ_NUM | Number(3,0) | SMALLINT NOT NULL | Sequence Number |
| 15 | RECIPIENT_COMM | Character(1) | VARCHAR2(1) NOT NULL | Recipient Communication |
| 16 | RELATIONSHIP_NBR | Number(2,0) | SMALLINT NOT NULL | Relationship Nbr |
| 17 | ORG_CONTACT | Number(4,0) | SMALLINT NOT NULL | Contact Nbr |
| 18 | ORG_DEPARTMENT | Number(3,0) | SMALLINT NOT NULL | Department Nbr |
| 19 | ORG_LOCATION | Number(3,0) | SMALLINT NOT NULL | Location Nbr |
| 20 | COMM_DTTM | DateTime(26) | TIMESTAMP | Communication DateTime |
| 21 | COMM_DT | Date(10) | DATE | Communication Date |
| 22 | LETTER_PRINTED_DT | Date(10) | DATE | Date letter was printed |
| 23 | COMMENT_PRINT_FLAG | Character(1) | VARCHAR2(1) NOT NULL | Print Comments for Communications |
| 24 | PROCESS_INSTANCE | Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 25 | COMM_COMMENTS | Long Character(2000) | VARCHAR2(2000) | Communication Comments |