PROCESS_INSTANCEEMPLIDCAL_RUN_IDEMPL_RCDGP_PAYGROUPCAL_IDORIG_CAL_RUN_IDRSLT_SEG_NUMSEG_END_DTSLICE_END_DTGPDE_BL_TYPEY/N Table Edit
GPDE_RP_AZ1_WRK(SQL Table) |
Index Back |
|---|---|
Work Record for AZ reportWork Record for AZ report |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PROCESS_INSTANCE |
Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 2 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 3 | CAL_RUN_ID |
Character(18) | VARCHAR2(18) NOT NULL | Calendar Run Id |
| 4 | EMPL_RCD |
Number(3,0) | SMALLINT NOT NULL | Empl Rcd Nbr |
| 5 | GP_PAYGROUP |
Character(10) | VARCHAR2(10) NOT NULL | Global Payroll pay group |
| 6 | CAL_ID |
Character(18) | VARCHAR2(18) NOT NULL | calendar id |
| 7 | ORIG_CAL_RUN_ID |
Character(18) | VARCHAR2(18) NOT NULL | Original Calendar Group ID |
| 8 | RSLT_SEG_NUM |
Number(4,0) | SMALLINT NOT NULL | Result Segment Number |
| 9 | SEG_END_DT |
Date(10) | DATE | Payee Process Segment's End Date |
| 10 | SLICE_END_DT |
Date(10) | DATE | Element Slice End Date |
| 11 | GPDE_BL_TYPE |
Character(1) | VARCHAR2(1) NOT NULL | Balance Type |
| 12 | PAY_ENTITY | Character(10) | VARCHAR2(10) NOT NULL | Pay Entity |
| 13 | PRD_END_DT | Date(10) | DATE | Pay Period End Date |
| 14 | GPDE_AL_CPAY_ENDDT | Date(10) | DATE | Current Pay End Date |
| 15 | GPDE_AZ_RP_001_11 | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | PT Grs Stat. Grs Inc |
| 16 | GPDE_AZ_RP_001_12 | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | PT Grs Once Stat. Grs Inc |
| 17 | GPDE_AZ_RP_001_53 | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | Base for Statutory Gross Inc |
| 18 | GPDE_AZ_RP_001_63 | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | Statutory Gross Increase |
| 19 | GPDE_AZ_RP_002_11 | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | PT Grs Recurr Stat. Min |
| 20 | GPDE_AZ_RP_002_12 | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | PT Grs Once Stat. Min |
| 21 | GPDE_AZ_RP_002_14 | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | PT Tax and SI-free Stat. |
| 22 | GPDE_AZ_RP_002_17 | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | Calculated Parttime Net |
| 23 | GPDE_AZ_RP_002_19 | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | PT Statutory TotalNet |
| 24 | GPDE_AZ_RP_002_21 | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | FT Grs Recurr Stat. Min. |
| 25 | GPDE_AZ_RP_002_22 | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | FT Grs Once Stat. Min. |
| 26 | GPDE_AZ_RP_002_28 | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | Statutory Flat Minimum Net |
| 27 | GPDE_AZ_RP_002_68 | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | Stat. Increase Min. Net. |
| 28 | GPDE_AZ_RP_003_11 | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | PT Grs Recurr Stat. DA |
| 29 | GPDE_AZ_RP_003_12 | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | PT Grs Once Stat. DA |
| 30 | GPDE_AZ_RP_003_15 | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | PT Overtime Pay Stat. |
| 31 | GPDE_AZ_RP_003_21 | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | FT Grs Recurr Stat. DA |
| 32 | GPDE_AZ_RP_003_22 | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | FT Grs Once Stat. DA |
| 33 | GPDE_AZ_RP_003_31 | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | Statutory DA Recurring Pay |
| 34 | GPDE_AZ_RP_003_32 | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | Stat DA onetime pay |
| 35 | GPDE_AZ_RP_003_36 | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | OAPT DA Stat. Marchclause |
| 36 | GPDE_AZ_RP_003_41 | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | Contr. Stat. DA Recurring Pay |
| 37 | GPDE_AZ_RP_003_42 | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | Contr. Stat. DA onetime pay |
| 38 | GPDE_AZ_RP_003_46 | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | Contr. Stat. DA Marchclause |
| 39 | GPDE_AZ_RP_003_ATD | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | SIP Gross in OAPT period |
| 40 | GPDE_AZ_RP_BBG_ATD | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | Yeartodate SIP-Limit in OAPT |
| 41 | GPDE_AZ_RP_BBG_MON | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | Monthly SIP-Limit for the EE |
| 42 | GPDE_AZ_RP_ELG_BON | Character(1) | VARCHAR2(1) NOT NULL | Eligible for AZ Bonus Calculation |
| 43 | GPDE_AZ_RP_ELG_FIL | Character(1) | VARCHAR2(1) NOT NULL | Eligible for Sick-Fill in AZ Calculation |
| 44 | GPDE_AZ_RP_ELG_MAR | Character(1) | VARCHAR2(1) NOT NULL | Eligible for Marchclause Calculation |
| 45 | GPDE_AZ_ELG_LINE10 | Character(1) | VARCHAR2(1) NOT NULL |
Provide Value in Report Line10
Y/N Table Edit |
| 46 | GPDE_AZ_RP_MBBG_AT | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | ATD Si-Limit last year |
| 47 | GPDE_AZ_RP_MRVB_AT | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | ATD-Gross Stat. OAPT MCC |
| 48 | BEGIN_DT | Date(10) | DATE | Begin Date |
| 49 | GPDE_AZ_IMODEL1 | Character(12) | VARCHAR2(12) NOT NULL | Descr |
| 50 | GPDE_AZ_IMODEL2 | Character(12) | VARCHAR2(12) NOT NULL | Descr |
| 51 | GPDE_AZ_RP_003_CUR | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | Real Amount Curr Period |
| 52 | GPDE_AZ_RP_003_FRM | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | Contributable Frame |
| 53 | GPDE_AZ_RP_003_GOA | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | Goal for Difference Amt |
| 54 | GPDE_AZ_RP_003_LIM | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | ATD SI-Limit |
| 55 | GPDE_AZ_RP_003_REA | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | Real Amount Contributed |
| 56 | GPDE_AZ_RP_003_TDA | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | Remaining Diff. Amt. |
| 57 | GPDE_AZ_RP_M003_13 | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | PT Gross unlimited OAPT MCC |
| 58 | GPDE_AZ_RP_M003_15 | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | Overtime in assignment period |
| 59 | GPDE_AZ_RP_M003_23 | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | FT Gross unlimited OAPT MCC |
| 60 | GPDE_AZ_RP_M003_31 | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | Statutory DA recurr pay |
| 61 | GPDE_AZ_RP_M003_32 | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | Statutory DA onetime pay |
| 62 | GPDE_AZ_RP_M003_CR | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | Total Real SI Gross unlim. MCC |