HRS_DM_CAT_IDHRS_DM_SUBCATHRS_DM_KEY_IDHRS_DM_VRTY_CMP(SQL View) |
Index Back |
|---|
| SELECT B.HRS_DM_CAT_ID , B.HRS_DM_SUBCAT , B.HRS_DM_KEY_ID , A.COMPETENCY_TXT FROM PS_HRS_APP_CMP A , PS_HRS_DM_KEY B WHERE A.COMPETENCY=B.HRS_DM_KEY_NAME AND A.COMPETENCY<>' ' AND A.COMPETENCY_TXT<>' ' AND B.HRS_DM_CAT_ID=4 |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | HRS_DM_CAT_ID |
Number(15,0) | DECIMAL(15) NOT NULL | Data Mapping Category ID |
| 2 | HRS_DM_SUBCAT |
Character(50) | VARCHAR2(50) NOT NULL | SubCategory |
| 3 | HRS_DM_KEY_ID |
Number(15,0) | DECIMAL(15) NOT NULL | Data Mapping Key ID |
| 4 | COMPETENCY_TXT | Character(30) | VARCHAR2(30) NOT NULL | Competency Text |