HGA_EVENTAWE_VW(SQL View) |
Index Back |
---|---|
Absence Event ViewThis is a shadow record of the GP_ABS_EVENT; This vw is used to populate the grid of events. Needs to review this view when there is change to GP_ABS_EVENT |
SELECT AE.TRANSACTION_NBR , AE.EMPLID , AE.EMPL_RCD , AE.BGN_DT , AE.PIN_TAKE_NUM , AE.END_DT , AE.ORIG_BEGIN_DT , AE.ABS_ENTRY_SRC , AE.PRC_EVT_ACTN_OPTN , AE.VOIDED_IND , AE.ABSENCE_REASON , AE.BEGIN_DAY_HRS , AE.BEGIN_DAY_HALF_IND , AE.END_DAY_HRS , AE.END_DAY_HALF_IND , AE.ALL_DAYS_IND , AE.START_TIME , AE.END_TIME , AE.START_TIME2 , AE.END_TIME2 , AE.EVT_CONFIG1 , AE.EVT_CONFIG2 , AE.EVT_CONFIG3 , AE.EVT_CONFIG4 , AE.EVT_CONFIG1_DT , AE.EVT_CONFIG2_DT , AE.EVT_CONFIG3_DT , AE.EVT_CONFIG4_DT , AE.EVT_CONFIG1_DEC , AE.EVT_CONFIG2_DEC , AE.EVT_CONFIG3_DEC , AE.EVT_CONFIG4_DEC , AE.EVT_CONFIG1_MON , AE.EVT_CONFIG2_MON , AE.EVT_CONFIG3_MON , AE.EVT_CONFIG4_MON , AE.CURRENCY_CD1 , AE.CURRENCY_CD2 , AE.CURRENCY_CD3 , AE.CURRENCY_CD4 , AE.MANAGER_APPR_IND , AE.OVRD_ENT_VAL , AE.OVRD_ADJ_VAL , AE.CAL_RUN_ID , AE.PYE_RUN_NUM , AE.LAST_UPDT_DT , AE.PROCESS_DT , AE.ABS_EVT_FCST_VAL , AE.FCST_DTTM , AE.DURATION_ABS , AE.DURATION_DYS , AE.DURATION_HOURS , AE.ACTION_DT_SS , AE.WF_STATUS , AE.TRANSACTION_NBR_EA , PIN.DESCR , SS.UNIT_TYPE , AE.FIRST_PROC_DT , AE.COMMENTS ,SS.EXCL_HOLIDAYS ,SS.EXCL_NON_WORK ,SS.START_END_HOL_RULE ,SS.START_END_OFF_RULE ,SS.REASON_REQUIRED ,SS.ALLOW_PARTIAL_DAYS ,SS.PARTIAL_DAYS_OPTN ,SS.FCST_IND ,SS.FCST_REQ_SUBMIT ,SS.FCST_REQ_APPROVAL , SS.FCST_MESSAGE ,SS.EOAWPRCS_ID ,SS.EOAWDEFN_ID , ST.OPRID , ST.EOAWSTEP_STATUS ,DAT.COUNTRY ,DAT.ELIG_GRP , PERS.LAST_NAME , PERS.NAME , SS.BAL_ACCUM_DISP_OPT , SS.CURR_BAL_ACCUM , EMPL.DEPTID , EMPL.HR_STATUS , EMPL.GP_PAYGROUP , EMPL.PAYGROUP , EMPL.OPRID FROM PS_GP_ABS_EVENT AE , PS_GP_PIN PIN ,PS_GP_ABS_SS SS , PS_GP_ABS_SS_DAT DAT , PS_PERSON_NAME PERS , PS_EMPLMT_SRCH_GBL EMPL , PS_GP_ABSSS_V_XREF X , PS_EOAW_STEP_VW ST WHERE SS.PIN_TAKE_NUM = AE.PIN_TAKE_NUM AND DAT.TRANSACTION_NBR = AE.TRANSACTION_NBR AND DAT.COUNTRY = SS.COUNTRY AND PIN.PIN_NUM = SS.PIN_TAKE_NUM AND AE.EMPLID = PERS.EMPLID AND AE.EMPLID = EMPL.EMPLID AND AE.EMPL_RCD = EMPL.EMPL_RCD AND %EffdtCheck(GP_ABS_SS, SS, AE.BGN_DT) AND X.EOAWTHREAD_ID = ST.EOAWTHREAD_ID AND X.EOAWPRCS_ID = ST.EOAWPRCS_ID AND AE.TRANSACTION_NBR = X.TRANSACTION_NBR AND X.EOAWPARENT_THREAD = ( SELECT MAX(Y.EOAWPARENT_THREAD) FROM PS_GP_ABSSS_V_XREF Y WHERE X.TRANSACTION_NBR = Y.TRANSACTION_NBR ) |
# | 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 | ORIG_BEGIN_DT | Date(10) | DATE |
original begin date
Default Value: GP_ABS_EVENT.BGN_DT |
8 | 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 |
9 | PRC_EVT_ACTN_OPTN | Character(1) | VARCHAR2(1) NOT NULL |
Process Action Event Indicator
N=Normal V=Void |
10 | VOIDED_IND | Character(1) | VARCHAR2(1) NOT NULL | Voided Indicator |
11 | ABSENCE_REASON | Character(3) | VARCHAR2(3) NOT NULL | absence reason |
12 | BEGIN_DAY_HRS | Signed Number(6,2) | DECIMAL(4,2) NOT NULL | Partial Hours |
13 | BEGIN_DAY_HALF_IND | Character(1) | VARCHAR2(1) NOT NULL |
indicates whether first day of an absence event began counts as half a day
Y/N Table Edit Default Value: N |
14 | END_DAY_HRS | Signed Number(6,2) | DECIMAL(4,2) NOT NULL | partial hours end |
15 | END_DAY_HALF_IND | Character(1) | VARCHAR2(1) NOT NULL |
half day end indicator
Y/N Table Edit Default Value: N |
16 | ALL_DAYS_IND | Character(1) | VARCHAR2(1) NOT NULL |
All Days Indicator
N=Apply To Begin Day Only Y=Apply To All Days Default Value: N |
17 | START_TIME | Time(15) | TIMESTAMP | Interview Start Time |
18 | END_TIME | Time(15) | TIMESTAMP | Interview End Time |
19 | START_TIME2 | Time(15) | TIMESTAMP | Contains End Time. Primarly created for storing Start Time of Absence Take |
20 | END_TIME2 | Time(15) | TIMESTAMP | Contains End Time. Primarly created for storing End Time of Absence Take |
21 | EVT_CONFIG1 | Character(10) | VARCHAR2(10) NOT NULL | config char |
22 | EVT_CONFIG2 | Character(10) | VARCHAR2(10) NOT NULL | config char |
23 | EVT_CONFIG3 | Character(10) | VARCHAR2(10) NOT NULL | config char |
24 | EVT_CONFIG4 | Character(10) | VARCHAR2(10) NOT NULL | config char |
25 | EVT_CONFIG1_DT | Date(10) | DATE | config date |
26 | EVT_CONFIG2_DT | Date(10) | DATE | config date |
27 | EVT_CONFIG3_DT | Date(10) | DATE | config date |
28 | EVT_CONFIG4_DT | Date(10) | DATE | config date |
29 | EVT_CONFIG1_DEC | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | config dec |
30 | EVT_CONFIG2_DEC | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | config dec |
31 | EVT_CONFIG3_DEC | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | config dec |
32 | EVT_CONFIG4_DEC | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | config dec |
33 | EVT_CONFIG1_MON | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | config monetary |
34 | EVT_CONFIG2_MON | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | config monetary |
35 | EVT_CONFIG3_MON | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | Config Monetary 3 |
36 | EVT_CONFIG4_MON | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | config monetary |
37 | CURRENCY_CD1 | Character(3) | VARCHAR2(3) NOT NULL |
Currency Code
Prompt Table: CURRENCY_CD_TBL |
38 | CURRENCY_CD2 | Character(3) | VARCHAR2(3) NOT NULL |
Currency Code
Prompt Table: CURRENCY_CD_TBL |
39 | CURRENCY_CD3 | Character(3) | VARCHAR2(3) NOT NULL |
currency code
Prompt Table: CURRENCY_CD_TBL |
40 | CURRENCY_CD4 | Character(3) | VARCHAR2(3) NOT NULL |
currency code
Prompt Table: CURRENCY_CD_TBL |
41 | MANAGER_APPR_IND | Character(1) | VARCHAR2(1) NOT NULL | Manager Approved |
42 | OVRD_ENT_VAL | Signed Number(12,6) | DECIMAL(10,6) NOT NULL | Override Entitlement Amoung |
43 | OVRD_ADJ_VAL | Signed Number(8,2) | DECIMAL(6,2) NOT NULL | Override Adjustment Amoung |
44 | CAL_RUN_ID | Character(18) | VARCHAR2(18) NOT NULL | Calendar Run Id |
45 | PYE_RUN_NUM | Number(8,0) | INTEGER NOT NULL | Number to link to Payee Run Table |
46 | LAST_UPDT_DT | Date(10) | DATE | Date of last Update |
47 | PROCESS_DT | Date(10) | DATE | Process Date |
48 | ABS_EVT_FCST_VAL | Character(30) | VARCHAR2(30) NOT NULL | This field is used on the GP_ABS_EVENT record to record the value of the resolved related forecast element. |
49 | FCST_DTTM | DateTime(26) | TIMESTAMP | This field is used on the GP_ABS_EVENT to record the last time forecasting was run for this event. |
50 | DURATION_ABS | Number(7,2) | DECIMAL(6,2) NOT NULL | Duration field containing 2 decimals to handle absence requirements |
51 | DURATION_DYS | Number(7,2) | DECIMAL(6,2) NOT NULL | Duration field containing 2 decimals to handle absence requirements |
52 | DURATION_HOURS | Number(7,2) | DECIMAL(6,2) NOT NULL | Duration (Hours) |
53 | ACTION_DT_SS | Date(10) | DATE | Date Submitted |
54 | 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 |
55 | TRANSACTION_NBR_EA | Number(15,0) | DECIMAL(15) NOT NULL |
The Extendned Absence transaction number
Default Value: 0 |
56 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
57 | UNIT_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Unit Type in which the absence balances are displayed
D=Days H=Hours |
58 | FIRST_PROC_DT | Date(10) | DATE | GP Core/Abs Mgt field to track when an absence was first processed. This date will not change regardless of how many retro runs are run against the absence subsequent to the initial calculation. |
59 | COMMENTS | Long Character | CLOB | Comment |
60 | EXCL_HOLIDAYS | Character(1) | VARCHAR2(1) NOT NULL |
This fields indicates if the end date calculation needs to substract holidays
N=No Y=Yes Default Value: N |
61 | EXCL_NON_WORK | Character(1) | VARCHAR2(1) NOT NULL |
This fields indicates if the end date calculation needs to substract days off
N=No Y=Yes Default Value: N |
62 | START_END_HOL_RULE | Character(1) | VARCHAR2(1) NOT NULL | This field is used to indicate whether the start or end date of an absence request can be scheduled for a holiday. |
63 | START_END_OFF_RULE | Character(1) | VARCHAR2(1) NOT NULL | This field is used to indicate whether the start or end date can be scheduled for an off-day |
64 | REASON_REQUIRED | Character(1) | VARCHAR2(1) NOT NULL |
This field indicates whether the Reason field is required.
Y/N Table Edit Default Value: N |
65 | ALLOW_PARTIAL_DAYS | Character(1) | VARCHAR2(1) NOT NULL |
This field indicates whether partial days are allowed for a particular absence take
Y/N Table Edit Default Value: N |
66 | PARTIAL_DAYS_OPTN | Character(1) | VARCHAR2(1) NOT NULL |
This field will be used to indicate what types of partial days are allowed
B=Partial Hours and Half Days D=Half Days H=Partial Hours N=None Default Value: N |
67 | FCST_IND | Character(1) | VARCHAR2(1) NOT NULL |
This field is used on the GP_PIN record to indicate whether or not the element should be processed during Forecasting.
Y/N Table Edit Default Value: N |
68 | FCST_REQ_SUBMIT | Character(1) | VARCHAR2(1) NOT NULL |
This field indicates whether Forecasting is required to submit an absence request.
Y/N Table Edit Default Value: N |
69 | FCST_REQ_APPROVAL | Character(1) | VARCHAR2(1) NOT NULL |
This field indicates whether Forecasting is required to approve an absence request.
Y/N Table Edit Default Value: N |
70 | FCST_MESSAGE | Character(1) | VARCHAR2(1) NOT NULL |
This field is used to indicate which type of Forecasting message to use as a result of Forecasting being complete, default message or a customized message.
C=Customized Message D=Default Message |
71 | EOAWPRCS_ID | Character(30) | VARCHAR2(30) NOT NULL | Approval Process ID |
72 | EOAWDEFN_ID | Character(30) | VARCHAR2(30) NOT NULL | Approval Framework Definition ID |
73 | OPRID | Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
74 | EOAWSTEP_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Step Instance Status
A=Approved B=Pushed back C=Auto Approved D=Denied E=Administrator denied F=Deleted G=Bypassed H=On Hold I=No Action Taken K=Skipped L=Terminated M=Administrator approved N=Not Active P=Pending R=No longer in role T=Terminated U=Auto approved X=Deleted Z=Pending Denial |
75 | COUNTRY | Character(3) | VARCHAR2(3) NOT NULL | Country |
76 | ELIG_GRP | Character(10) | VARCHAR2(10) NOT NULL | eligibility group |
77 | LAST_NAME | Character(30) | VARCHAR2(30) NOT NULL | Last Name |
78 | NAME | Character(50) | VARCHAR2(50) NOT NULL | Name |
79 | BAL_ACCUM_DISP_OPT | Character(1) | VARCHAR2(1) NOT NULL |
This field will dictate how the current balance will be calculated and displayed on the self-service pages.
N=Not Summarized S=Summarized |
80 | CURR_BAL_ACCUM | Number(8,0) | INTEGER NOT NULL | This field is used to contain the pin number of the accumulator that will represent the current balance of the entitlements. |
81 | DEPTID | Character(10) | VARCHAR2(10) NOT NULL | Department |
82 | HR_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
HR Status
A=Active I=Inactive |
83 | GP_PAYGROUP | Character(10) | VARCHAR2(10) NOT NULL | Global Payroll pay group |
84 | PAYGROUP | Character(3) | VARCHAR2(3) NOT NULL | Pay Group |
85 | OPRID2 | Character(30) | VARCHAR2(30) NOT NULL | User ID |