COMMON_IDSEQ_3CENCL_SEQ_NUMENCLOSURES(SQL View) |
Index Back |
|---|---|
CommGen Enclosure viewCommGen Enclosure view is used to build the Communication Data Source with the enclosure data. |
| SELECT A.COMMON_ID ,A.SEQ_3C ,A.ENCL_SEQ_NUM ,A.ENCL_LTR_CD ,B.DESCR ,B.DESCRSHORT ,A.COMMENTS FROM PS_ENCLOSURE_COMM A , PS_SCC_STN_LTR_TBL B WHERE A.ENCL_LTR_CD = B.SCC_LETTER_CD |
| # | 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 | ENCL_SEQ_NUM |
Number(3,0) | SMALLINT NOT NULL | Sequence Number |
| 4 | ENCL_LTR_CD | Character(3) | VARCHAR2(3) NOT NULL | Enclosure Code |
| 5 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 6 | DESCRSHORT | Character(10) | VARCHAR2(10) NOT NULL | Short Description |
| 7 | COMMENTS | Long Character | CLOB | Comment |