COMMON_IDINSTITUTIONDefault Value: OPR_DEF_TBL_CS.INSTITUTION
Prompt Table: INSTITUTION_TBL
ADMIN_FUNCTIONCMNT_CATEGORYPrompt Table: CMNT_CATG_TBL
CMNT_IDCMNT_ID_VW(SQL View) |
Index Back |
|---|---|
Person Comment Category ViewCMNT_ID_VW is used as DERIVED_CM1.CMNT_ID |
| SELECT DISTINCT a.common_id , a.institution , a.admin_function , a.cmnt_category , a.cmnt_id , b.name FROM PS_PERSON_COMMENT a , PS_SCC_PRI_NAME_VW b WHERE a.common_id = b.emplid |
| # | 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 | INSTITUTION |
Character(5) | VARCHAR2(5) NOT NULL |
Academic Institution
Default Value: OPR_DEF_TBL_CS.INSTITUTION Prompt Table: INSTITUTION_TBL |
| 3 | ADMIN_FUNCTION |
Character(4) | VARCHAR2(4) NOT NULL | Administrative Function |
| 4 | CMNT_CATEGORY |
Character(6) | VARCHAR2(6) NOT NULL |
Comment Category
Prompt Table: CMNT_CATG_TBL |
| 5 | CMNT_ID |
Character(11) | VARCHAR2(11) NOT NULL | Comment ID |
| 6 | NAME | Character(50) | VARCHAR2(50) NOT NULL | Name |