EMPLIDEMPL_RCDTRANSACTION_NBRA=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
GP_ABS_FMLA_VW(SQL View) |
Index Back |
|---|---|
FMLA TransactionsFMLA transactions |
| SELECT EA.EMPLID , EA.EMPL_RCD , EA.TRANSACTION_NBR , EV.BGN_DT , EV.END_DT , EV.WF_STATUS , EV.DURATION_ABS , EV.OVRD_ENT_VAL , EV.OVRD_ADJ_VAL , F.GP_ABS_FMLA_YR_BGN , F.GP_ABS_FMLA_LV_RQT , F.GP_ABS_FMLA_LV_TKN , F.GP_ABS_FMLA_LV_AVL , F.GP_ABS_FMLA_ENTITL , T.TAKE_CONFIG1 , P.DESCR FROM PS_GP_ABS_EA EA , PS_GP_ABS_FMLA_ELG F , PS_GP_ABS_EVENT EV , PS_GP_ABS_TAKE T , PS_GP_PIN P WHERE F.EMPLID = EA.EMPLID AND F.EMPL_RCD = EA.EMPL_RCD AND F.TRANSACTION_NBR = EA.TRANSACTION_NBR AND EA.PIN_TAKE_NUM = T.PIN_NUM AND T.ABS_TYPE_OPTN = 'FML' AND EV.EMPLID = EA.EMPLID AND EV.EMPL_RCD = EA.EMPL_RCD AND EV.TRANSACTION_NBR_EA = F.TRANSACTION_NBR AND P.PIN_NUM = T.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 | 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. |
| 4 | BGN_DT | Date(10) | DATE | Begin Date |
| 5 | END_DT | Date(10) | DATE | end date |
| 6 | 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 |
| 7 | DURATION_ABS | Number(7,2) | DECIMAL(6,2) NOT NULL | Duration field containing 2 decimals to handle absence requirements |
| 8 | OVRD_ENT_VAL | Signed Number(12,6) | DECIMAL(10,6) NOT NULL | Override Entitlement Amoung |
| 9 | OVRD_ADJ_VAL | Signed Number(8,2) | DECIMAL(6,2) NOT NULL | Override Adjustment Amoung |
| 10 | GP_ABS_FMLA_YR_BGN | Date(10) | DATE | FMLA year begin date |
| 11 | GP_ABS_FMLA_LV_RQT | Number(3,0) | SMALLINT NOT NULL | FMLA leave requested |
| 12 | GP_ABS_FMLA_LV_TKN | Number(3,0) | SMALLINT NOT NULL | FMLA leave taken |
| 13 | GP_ABS_FMLA_LV_AVL | Number(3,0) | SMALLINT NOT NULL | FMLA leave available |
| 14 | GP_ABS_FMLA_ENTITL | Number(3,0) | SMALLINT NOT NULL | FMLA entitlement |
| 15 | TAKE_CONFIG1 | Character(10) | VARCHAR2(10) NOT NULL | Field reserved for custom attribution to an Absence Take |
| 16 | GP_ABS_FMLA_TYP_NM | Character(30) | VARCHAR2(30) NOT NULL | FMLA Type |