EMPLIDEMPL_RCDPRD_BGN_DTPRD_END_DTD=Days
H=Hours
D=Days
H=Hours
HGA_PRD_TAKE_VW(SQL View) |
Index Back |
|---|---|
Absence Accumulator ResultsAbsence Balance and Take Accumulator Results used by AM pivots. |
| SELECT TMP.EMPLID , TMP.EMPL_RCD , TMP.PRD_BGN_DT , TMP.PRD_END_DT , TMP.FREQUENCY_ID , TMP.TOTAL_DURATION_DYS , TMP.TOTAL_DURATION_HRS , TMP.FISCAL_YEAR , TMP.CALENDAR_YEAR , TMP.UNIT_TYPE , TMP.UNIT_TYPE , CASE WHEN TMP.UNIT_TYPE = 'H' THEN TMP.TOTAL_DURATION_HRS ELSE TMP.TOTAL_DURATION_DYS END , SUM(TMP.ABS_TAKE_CAL_VAL ) FROM PS_HGA_RSLTACM_TMP TMP WHERE TMP.ABS_AC_TYPE = 'T' GROUP BY TMP.EMPLID , TMP.EMPL_RCD , TMP.PRD_BGN_DT , TMP.PRD_END_DT, TMP.FREQUENCY_ID, TMP.TOTAL_DURATION_DYS , TMP.TOTAL_DURATION_HRS, TMP.FISCAL_YEAR, TMP.CALENDAR_YEAR, TMP.UNIT_TYPE |
| # | 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 | PRD_BGN_DT |
Date(10) | DATE | Period Begin Date |
| 4 | PRD_END_DT |
Date(10) | DATE | Pay Period End Date |
| 5 | FREQUENCY_ID | Character(5) | VARCHAR2(5) NOT NULL | Defines a frequency and a set of parameters used for frequency conversion. Typically, these frequencies reflect how often an event occurs. Some examples are compensation frequency and pay frequency. |
| 6 | TOTAL_DURATION_DYS | Number(9,2) | DECIMAL(8,2) NOT NULL | Total Duration Days |
| 7 | TOTAL_DURATION_HRS | Number(9,2) | DECIMAL(8,2) NOT NULL | Total Duration Hours |
| 8 | FISCAL_YEAR | Number(4,0) | SMALLINT NOT NULL | Fiscal Year |
| 9 | CALENDAR_YEAR | Number(4,0) | SMALLINT NOT NULL | Calendar Year |
| 10 | UNIT_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Unit Type in which the absence balances are displayed
D=Days H=Hours |
| 11 | HGA_UNIT_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Unit Type in which the absence balances are displayed
D=Days H=Hours |
| 12 | TOTAL_DURATION_ABS | Number(9,2) | DECIMAL(8,2) NOT NULL | Total Duration Days |
| 13 | ABS_TAKE_CAL_VAL | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | Absence Take for current period. |