EMPLIDEMPL_RCDD=Days
H=Hours
HR_TEAM_GPBL_VW(SQL View) |
Index Back |
|---|---|
GP Absence BalancesGets GP absence balances and description for use in My Team fluid page. |
| SELECT GP.EMPLID , GP.EMPL_RCD , PN.DESCR , GP.ACM_THRU_DT , GP.CALC_RSLT_VAL , GP.UNIT_TYPE , GP.SEG_END_DT FROM PS_GP_ABSBAL_FL_VW GP , PS_GP_PIN PN WHERE GP.PIN_ENTL_BAL_NUM = PN.PIN_NUM |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 2 | EMPL_RCD |
Number(3,0) | SMALLINT NOT NULL | Empl Record |
| 3 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 4 | ACM_THRU_DT | Date(10) | DATE | Through Date |
| 5 | CALC_RSLT_VAL | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | Calculation Numeric Result |
| 6 | UNIT_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Unit Type in which the absence balances are displayed
D=Days H=Hours |
| 7 | SEG_END_DT | Date(10) | DATE | Payee Process Segment's End Date |