HGA_BAL_HIST_VW(SQL View) |
Index Back |
---|---|
List of Events by TakeSelf Service Absence History outer join with workflow status |
SELECT DAT.TRANSACTION_NBR , DAT.EMPLID , DAT.EMPL_RCD , DAT.BGN_DT , DAT.PIN_TAKE_NUM , DAT.END_DT , B.PIN_ENTL_BAL_NUM , DAT.ORIG_BEGIN_DT , DAT.ORIG_PIN_TAKE_NUM , DAT.ORIG_END_DT , DAT.COUNTRY , DAT.ELIG_GRP , AE.ABS_ENTRY_SRC , AE.DURATION_ABS , AE.VOIDED_IND , AE.PRC_EVT_ACTN_OPTN , AE.MANAGER_APPR_IND , AE.WF_STATUS , AE.PROCESS_DT , PIN.COUNTRY , PIN.DESCR , SS.UNIT_TYPE FROM PS_GP_ABS_SS_DAT DAT , PS_GP_ABS_EVENT AE , PS_GP_PIN PIN , PS_GP_ABS_SS SS , PS_GP_PIN_CMPNT B , PS_GP_ABS_TAKE_ENT C WHERE AE.TRANSACTION_NBR = DAT.TRANSACTION_NBR AND AE.EMPLID = DAT.EMPLID AND AE.EMPL_RCD = DAT.EMPL_RCD AND AE.BGN_DT = DAT.ORIG_BEGIN_DT AND AE.PIN_TAKE_NUM = DAT.ORIG_PIN_TAKE_NUM AND AE.END_DT = DAT.ORIG_END_DT AND SS.COUNTRY = DAT.COUNTRY AND SS.PIN_TAKE_NUM = DAT.ORIG_PIN_TAKE_NUM AND %EffdtCheck(GP_ABS_SS, SS, DAT.BGN_DT) AND PIN.PIN_NUM = DAT.ORIG_PIN_TAKE_NUM AND (PIN.USED_BY = 'A' OR PIN.COUNTRY = SS.COUNTRY) AND C.PIN_ENT_NUM = B.PIN_NUM AND C.PRIORITY = ( SELECT MIN(PRIORITY) FROM PS_GP_ABS_TAKE_ENT GATE WHERE GATE.PIN_ENT_NUM = C.PIN_ENT_NUM) AND AE.PIN_TAKE_NUM = C.PIN_NUM AND AE.PROCESS_DT IS NULL |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | TRANSACTION_NBR | Number(15,0) | DECIMAL(15) NOT NULL | 08/02/99 NAS: Changed the size of this field from 10 to 15. Based on Jim Hillman's decision to make the field at a standard size. |
2 | EMPLID | Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
3 | EMPL_RCD | Number(3,0) | SMALLINT NOT NULL | Empl Record |
4 | BGN_DT | Date(10) | DATE NOT NULL | Begin Date |
5 | PIN_TAKE_NUM | Number(8,0) | INTEGER NOT NULL |
Absence Take
Prompt Table: GP_PIN_ABSTK_VW |
6 | END_DT | Date(10) | DATE NOT NULL | end date |
7 | PIN_ENTL_BAL_NUM | Number(8,0) | INTEGER NOT NULL | Element number field |
8 | ORIG_BEGIN_DT | Date(10) | DATE | original begin date |
9 | ORIG_PIN_TAKE_NUM | Number(8,0) | INTEGER NOT NULL | Absence Take |
10 | ORIG_END_DT | Date(10) | DATE | Unadjusted End Date |
11 | COUNTRY2 | Character(3) | VARCHAR2(3) NOT NULL | Country |
12 | ELIG_GRP | Character(10) | VARCHAR2(10) NOT NULL | eligibility group |
13 | ABS_ENTRY_SRC | Character(1) | VARCHAR2(1) NOT NULL |
Absence Entry Source
1=Administrator Absence Event 2=Time & Labor 3=Third Party 4=Employee Absence Request 5=Manager Absence Request 6=Employee Timesheet 7=Manager Timesheet A=Employee Extended Absence B=Manager Extended Absence C=Administrator Extended Absence D=Employee Desktop Integration |
14 | DURATION_ABS | Number(7,2) | DECIMAL(6,2) NOT NULL | Duration field containing 2 decimals to handle absence requirements |
15 | VOIDED_IND | Character(1) | VARCHAR2(1) NOT NULL | Voided Indicator |
16 | PRC_EVT_ACTN_OPTN | Character(1) | VARCHAR2(1) NOT NULL |
Process Action Event Indicator
N=Normal V=Void |
17 | MANAGER_APPR_IND | Character(1) | VARCHAR2(1) NOT NULL | Manager Approved |
18 | WF_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Workflow Status
A=Approved C=Cancelled D=Denied E=Error. Contact Administrator. F=Awaiting final approval I=In Approval Process M=Administrator is Processing N=Not Available P=Rework S=Submitted V=Data Saved |
19 | PROCESS_DT | Date(10) | DATE | Process Date |
20 | COUNTRY | Character(3) | VARCHAR2(3) NOT NULL | Country |
21 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
22 | UNIT_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Unit Type in which the absence balances are displayed
D=Days H=Hours |