PROBINSTPERSON_IDRF_UTIL_WHRS_VW(SQL View) |
Index Back |
|---|---|
Work Hours - Utilization RateInput view for work hours - utilization rate ACE report |
| SELECT K.PROBINST , A.PERSON_ID , A.TOTAL_HOURS FROM PS_RF_UTIL_WRK_TBL A , PS_RF_UTIL_CONFIG J , PS_RF_UTIL_CF_INST K WHERE A.UUID_RAW = K.UUID_RAW AND J.OPRID = K.OPRID AND J.RUN_CNTL_ID = K.RUN_CNTL_ID |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PROBINST |
Character(20) | VARCHAR2(20) NOT NULL | Optimization Problem Instance |
| 2 | PERSON_ID |
Character(15) | VARCHAR2(15) NOT NULL | Person ID |
| 3 | TOTAL_HOURS | Signed Number(13,2) | DECIMAL(11,2) NOT NULL | This field is used to store the Total Hours. |