HRS_DM_CAT_IDHRS_DM_SUBCATHRS_DM_KEY_IDHRS_DM_VRTY_SCH(SQL View) |
Index Back |
|---|
| SELECT B.HRS_DM_CAT_ID , B.HRS_DM_SUBCAT , B.HRS_DM_KEY_ID , A.SCHOOL FROM PS_HRS_APP_ACMP_I A , PS_HRS_DM_KEY B WHERE A.SCHOOL_CODE=B.HRS_DM_KEY_NAME AND A.SCHOOL_CODE<>' ' AND A.SCHOOL<>' ' AND B.HRS_DM_CAT_ID=7 AND (A.COUNTRY_OTHER=B.HRS_DM_SUBCAT OR B.HRS_DM_SUBCAT=' ') |
| # | 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 | SCHOOL | Character(30) | VARCHAR2(30) NOT NULL | School Name |