HRS_DM_CAT_IDHRS_DM_SUBCATHRS_DM_KEY_IDHRS_DM_VRTY_DEG(SQL View) |
Index Back |
|---|
| SELECT B.HRS_DM_CAT_ID , B.HRS_DM_SUBCAT , B.HRS_DM_KEY_ID , A.ACCOMPLISHMENT_TXT FROM PS_HRS_APP_ACMP_I A , PS_HRS_DM_KEY B , PS_HRS_ACCOM_TBL_I C WHERE A.ACCOMPLISHMENT=B.HRS_DM_KEY_NAME AND A.ACCOMPLISHMENT=C.ACCOMPLISHMENT AND A.ACCOMPLISHMENT<>' ' AND A.ACCOMPLISHMENT_TXT<>' ' AND C.ACCOMP_CATEGORY='DEG' AND B.HRS_DM_CAT_ID=5 |
| # | 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 | ACCOMPLISHMENT_TXT | Character(30) | VARCHAR2(30) NOT NULL | Accomplishment Text |