EMPLIDEMPL_RCDPIN_ENTL_BAL_NUMACM_FROM_DTACM_THRU_DT1=Segment
2=Calendar Period
3=Month to Date
4=Quarter to Date
5=Year to Date
6=Custom Period
USER_KEY1USER_KEY2USER_KEY3USER_KEY4USER_KEY5USER_KEY6D=Days
H=Hours
HGA_BALSS_TMP(SQL Table) |
Index Back |
|---|---|
Absence BalancesAbsence Balances |
| # | 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 | PIN_ENTL_BAL_NUM |
Number(8,0) | INTEGER NOT NULL | Element number field |
| 4 | ACM_FROM_DT |
Date(10) | DATE | From Date |
| 5 | ACM_THRU_DT |
Date(10) | DATE | Through Date |
| 6 | ACM_PRD_OPTN | Character(1) | VARCHAR2(1) NOT NULL |
Accumulator Period
1=Segment 2=Calendar Period 3=Month to Date 4=Quarter to Date 5=Year to Date 6=Custom Period |
| 7 | USER_KEY1 |
Character(25) | VARCHAR2(25) NOT NULL | User Key 1 |
| 8 | USER_KEY2 |
Character(25) | VARCHAR2(25) NOT NULL | User Key 2 |
| 9 | USER_KEY3 |
Character(25) | VARCHAR2(25) NOT NULL | User Key 3 |
| 10 | USER_KEY4 |
Character(25) | VARCHAR2(25) NOT NULL | User Key 4 |
| 11 | USER_KEY5 |
Character(25) | VARCHAR2(25) NOT NULL | User Key 5 |
| 12 | USER_KEY6 |
Character(25) | VARCHAR2(25) NOT NULL | User Key 6 |
| 13 | CALC_RSLT_VAL | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | Calculation Numeric Result |
| 14 | UNIT_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Unit Type in which the absence balances are displayed
D=Days H=Hours |
| 15 | PRD_END_DT | Date(10) | DATE | Pay Period End Date |