HRS_DM_CAT_IDHRS_DM_SUBCATHRS_DM_KEY_IDHRS_DM_VRTY_MJR(SQL View) |
Index Back |
|---|
| SELECT B.HRS_DM_CAT_ID , B.HRS_DM_SUBCAT , B.HRS_DM_KEY_ID , A.MAJOR FROM PS_HRS_APP_ACMP_I A , PS_HRS_DM_KEY B WHERE A.MAJOR_CODE=B.HRS_DM_KEY_NAME AND A.MAJOR_CODE<>' ' AND A.MAJOR<>' ' AND B.HRS_DM_CAT_ID=6 |
| # | 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 | MAJOR | Character(30) | VARCHAR2(30) NOT NULL | Major |