EMPLIDPIN_NUMGPUS_ACBAL_VW(SQL View) |
Index Back |
|---|---|
Balance ViewGarnishment Balance Accumulator View |
| SELECT DISTINCT EMPLID , PIN_NUM , SEQ_NUM8 , CALC_RSLT_VAL , USER_KEY1 ,USER_KEY2 FROM PS_GP_RSLT_ACUM F WHERE F.CAL_RUN_ID = ( SELECT C.CAL_RUN_ID FROM PS_GP_CAL_RUN C WHERE C.RUN_FINALIZED_TS = ( SELECT MAX(A.RUN_FINALIZED_TS) FROM PS_GP_CAL_RUN A WHERE A.CAL_RUN_ID IN ( SELECT B.CAL_RUN_ID FROM PS_GP_PYE_PRC_STAT B WHERE B.EMPLID = F.EMPLID))) AND F.CAL_ID = ( SELECT D.CAL_ID FROM PS_GP_CAL_RUN_DTL D WHERE F.CAL_ID = D.CAL_ID AND D.CAL_FINAL_TS = ( SELECT MAX(G.CAL_FINAL_TS) FROM PS_GP_CAL_RUN_DTL G WHERE G.CAL_ID = F.CAL_ID)) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 2 | PIN_NUM |
Number(8,0) | INTEGER NOT NULL | PIN Number |
| 3 | SEQ_NUM8 | Number(8,0) | INTEGER NOT NULL | Sequence Number |
| 4 | CALC_RSLT_VAL | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | Calculation Numeric Result |
| 5 | USER_KEY1 | Character(25) | VARCHAR2(25) NOT NULL | User Key 1 |
| 6 | USER_KEY2 | Character(25) | VARCHAR2(25) NOT NULL | User Key 2 |