UPG_E3XW_TAO(SQL Table) |
Index Back |
|---|
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SETID | Character(5) | VARCHAR2(5) NOT NULL | SetID |
| 2 | EMPLID | Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 3 | EFFDT | Date(10) | DATE | Effective Date |
| 4 | ACTION_DATE | Date(10) | DATE | Date of action |
| 5 | ACTION_DT | Date(10) | DATE | Action Date |
| 6 | ACTIVITY_DT | Date(10) | DATE | Activity Date |
| 7 | ADJUST_DATE1 | Date(10) | DATE | Date 1 Constant |
| 8 | ADJUST_DATE2 | Date(10) | DATE | Date 2 Constant |
| 9 | AGREEMENT_DT | Date(10) | DATE | Agreement Date |
| 10 | STATE | Character(6) | VARCHAR2(6) NOT NULL | State |
| 11 | STATE2 | Character(6) | VARCHAR2(6) NOT NULL | State |
| 12 | TAX_CLASS | Character(1) | VARCHAR2(1) NOT NULL | Tax Balance Class |
| 13 | TAX_CLASS_CAN | Character(3) | VARCHAR2(3) NOT NULL |
Canadian Tax Class
ALL=Total Gross CBT=Canadian Bonus Tax CIT=Canadian Income Tax (T4) CPA=Pension Adjustment CPP=Canada Pension Plan Employee CPR=Canada Pension Plan Employer EIE=Employment Insurance Employee EIR=Employment Insurance Employer HTX=Provincial Health Tax PYT=Payroll Tax QBT=Quebec Bonus Tax QCD=Quebec Tax Deduction QIE=Quebec Parental Plan Employee QIR=Quebec Parental Plan Employer QIT=Quebec Income Tax (RL-1) QPP=Quebec Pension Plan Employee QPR=Quebec Pension Plan Employer RV2=Quebec Income Tax (RL-2) T4A=Canadian Income Tax (T4A) TRV=True RL TT4=True T4 |
| 14 | FROMDATE | Date(10) | DATE | From Date |
| 15 | THRUDATE | Date(10) | DATE | End Date |
| 16 | BEGIN_DT | Date(10) | DATE | Begin Date |
| 17 | END_DT | Date(10) | DATE | end date |
| 18 | PAY_END_DT | Date(10) | DATE | Pay Period End Date |
| 19 | YEAR_DAY | Number(2,0) | SMALLINT NOT NULL | Day of Month in Year |
| 20 | YEAR_MONTH | Number(2,0) | SMALLINT NOT NULL | Month of Year |
| 21 | YEAR_DISPLAY | Number(4,0) | SMALLINT NOT NULL | Year Display |
| 22 | YEAR_START_DT | Date(10) | DATE | Year Start Date |
| 23 | COMPANY | Character(3) | VARCHAR2(3) NOT NULL | Company |
| 24 | COMPANY_ALT | Character(3) | VARCHAR2(3) NOT NULL | Company |
| 25 | DESCR15 | Character(15) | VARCHAR2(15) NOT NULL | Short Description |
| 26 | ADJ_REASON | Character(50) | VARCHAR2(50) NOT NULL | Adjustment Reason |
| 27 | DESCR20 | Character(20) | VARCHAR2(20) NOT NULL | Description |
| 28 | DESCR25 | Character(25) | VARCHAR2(25) NOT NULL | Description - Part 1 |
| 29 | DESCRSHORT | Character(10) | VARCHAR2(10) NOT NULL | Short Description |
| 30 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 31 | DESCR25_2 | Character(25) | VARCHAR2(25) NOT NULL | Description - Part 2 |
| 32 | DESCR2_GER | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 33 | DESCR3_GER | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 34 | DESCR4_GER | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 35 | DESCR5_GER | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 36 | DESCR_DED | Character(30) | VARCHAR2(30) NOT NULL | Deduction Description |
| 37 | DESCR_GRV_STEP | Character(30) | VARCHAR2(30) NOT NULL | Grievance Step Description |
| 38 | DESCR_INC_TYPE | Character(30) | VARCHAR2(30) NOT NULL | Incident Type Description |
| 39 | DESCR_AC | Character(30) | VARCHAR2(30) NOT NULL | Alternate Char Description |
| 40 | DESCR_ACT_TYPE | Character(30) | VARCHAR2(30) NOT NULL | Action Type Description |
| 41 | DESCR_BENPGM | Character(30) | VARCHAR2(30) NOT NULL | Benefit Program |
| 42 | DESCR50 | Character(50) | VARCHAR2(50) NOT NULL | Description of length 50 |
| 43 | DESCR100 | Character(100) | VARCHAR2(100) NOT NULL | Length 100 Description |
| 44 | DESCR100_GER | Character(100) | VARCHAR2(100) NOT NULL | Description 100 Characters |
| 45 | ELIG_FLG_CNFIG1 | Character(1) | VARCHAR2(1) NOT NULL |
Eligible or Ineligible
E=Eligible I=Ineligible |
| 46 | ELIG_FLG_CNFIG2 | Character(1) | VARCHAR2(1) NOT NULL |
Eligible or Ineligible
E=Eligible I=Ineligible |
| 47 | ELIG_FLG_CNFIG3 | Character(1) | VARCHAR2(1) NOT NULL |
Eligible or Ineligible
E=Eligible I=Ineligible |
| 48 | ELIG_CONFIG1 | Character(10) | VARCHAR2(10) NOT NULL | This field is simply an unformatted and unvalidated character field which can be used to specify special benefits eligibility parameters for the employee, when the built-in eligibility rules are insufficient. This is one of nine similar fields. |
| 49 | ELIG_CONFIG2 | Character(10) | VARCHAR2(10) NOT NULL | This field is simply an unformatted and unvalidated character field which can be used to specify special benefits eligibility parameters for the employee, when the built-in eligibility rules are insufficient. This is one of nine similar fields. |
| 50 | ELIG_CONFIG3 | Character(10) | VARCHAR2(10) NOT NULL | This field is simply an unformatted and unvalidated character field which can be used to specify special benefits eligibility parameters for the employee, when the built-in eligibility rules are insufficient. This is one of nine similar fields. |
| 51 | ELIG_CONFIG4 | Character(10) | VARCHAR2(10) NOT NULL | This field is simply an unformatted and unvalidated character field which can be used to specify special benefits eligibility parameters for the employee, when the built-in eligibility rules are insufficient. This is one of nine similar fields. |
| 52 | ELIG_CONFIG5 | Character(10) | VARCHAR2(10) NOT NULL | This field is simply an unformatted and unvalidated character field which can be used to specify special benefits eligibility parameters for the employee, when the built-in eligibility rules are insufficient. This is one of nine similar fields. |
| 53 | ELIG_CONFIG6 | Character(10) | VARCHAR2(10) NOT NULL | This field is simply an unformatted and unvalidated character field which can be used to specify special benefits eligibility parameters for the employee, when the built-in eligibility rules are insufficient. This is one of nine similar fields. |
| 54 | ELIG_CONFIG7 | Character(10) | VARCHAR2(10) NOT NULL | This field is simply an unformatted and unvalidated character field which can be used to specify special benefits eligibility parameters for the employee, when the built-in eligibility rules are insufficient. This is one of nine similar fields. |
| 55 | ELIG_CONFIG8 | Character(10) | VARCHAR2(10) NOT NULL | This field is simply an unformatted and unvalidated character field which can be used to specify special benefits eligibility parameters for the employee, when the built-in eligibility rules are insufficient. This is one of nine similar fields. |
| 56 | ELIG_CONFIG9 | Character(10) | VARCHAR2(10) NOT NULL | This field is simply an unformatted and unvalidated character field which can be used to specify special benefits eligibility parameters for the employee, when the built-in eligibility rules are insufficient. This is one of nine similar fields. |
| 57 | DATA_KEY1_DEC | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | Data Key - Decimal |
| 58 | DATA_KEY2_DEC | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | Data Key - Decimal |
| 59 | DATA_KEY3_DEC | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | Data Key - Decimal |
| 60 | DATA_KEY4_DEC | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | Data Key - Decimal |
| 61 | DATA_KEY5_DEC | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | Data Key - Decimal |
| 62 | DATA_VAL1_DEC | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | Data Value - Decimal |
| 63 | DATA_VAL2_DEC | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | Data Value - Decimal |
| 64 | DATA_VAL3_DEC | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | Data Value - Decimal |
| 65 | DATA_VAL4_DEC | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | Data Value - Decimal |
| 66 | DATA_VAL5_DEC | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | Data Value - Decimal |
| 67 | DATA_VAL6_DEC | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | Data Value - Decimal |
| 68 | DATA_VAL7_DEC | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | Data Value - Decimal |
| 69 | DATA_VAL8_DEC | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | Data Value - Decimal |
| 70 | PI_CHECK_RT1 | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | User Defined Check Rate 1 |
| 71 | BALANCE_PERIOD | Number(3,0) | SMALLINT NOT NULL | Balances for Period |
| 72 | BALANCE_QTR | Number(3,0) | SMALLINT NOT NULL | Balances for Quarter |
| 73 | BALANCE_YEAR | Number(4,0) | SMALLINT NOT NULL | Balances for Year |
| 74 | CURRENT_YEAR | Number(4,0) | SMALLINT NOT NULL | Current Year |
| 75 | LINE_NUM | Number(2,0) | SMALLINT NOT NULL | Line # |
| 76 | MONTH1 | Number(2,0) | SMALLINT NOT NULL | Month 1 |
| 77 | MONTH2 | Number(2,0) | SMALLINT NOT NULL | Month 2 |
| 78 | MONTH3 | Number(2,0) | SMALLINT NOT NULL | Month 3 |
| 79 | PAGE_NUM | Number(4,0) | SMALLINT NOT NULL | Page # |
| 80 | SEPCHK | Number(1,0) | SMALLINT NOT NULL | Separate check number. |
| 81 | NLGRS_ADJ | Signed Number(12,2) | DECIMAL(10,2) NOT NULL | No Limit Gross Adjustment |
| 82 | NLGRS_CUR | Signed Number(12,2) | DECIMAL(10,2) NOT NULL | Current No Limit Gross |
| 83 | NLGRS_MTD | Signed Number(12,2) | DECIMAL(10,2) NOT NULL | No Limit Gross MTD |
| 84 | NLGRS_MTD_ADJ | Signed Number(12,2) | DECIMAL(10,2) NOT NULL | No Limit Gross MTD Adjusted |
| 85 | NLGRS_QTD | Signed Number(12,2) | DECIMAL(10,2) NOT NULL | No Limit Gross QTD |
| 86 | NLGRS_QTD_ADJ | Signed Number(12,2) | DECIMAL(10,2) NOT NULL | No Limit Gross QTD Adjusted |
| 87 | NLGRS_YTD | Signed Number(12,2) | DECIMAL(10,2) NOT NULL | No Limit Gross YTD |
| 88 | NLGRS_YTD_ADJ | Signed Number(12,2) | DECIMAL(10,2) NOT NULL | No Limit Gross YTD Adjusted |
| 89 | TAX_ADJ | Signed Number(12,2) | DECIMAL(10,2) NOT NULL | Tax Adjustment |
| 90 | TAX_AGG | Signed Number(12,2) | DECIMAL(10,2) NOT NULL | Tax Aggregate |
| 91 | TAX_CUR | Signed Number(12,2) | DECIMAL(10,2) NOT NULL | Current Tax |
| 92 | TAX_MTD | Signed Number(12,2) | DECIMAL(10,2) NOT NULL | Tax MTD |
| 93 | TAX_MTD_ADJ | Signed Number(12,2) | DECIMAL(10,2) NOT NULL | Tax MTD Adjusted |
| 94 | TAX_NOT_TAKEN | Signed Number(12,2) | DECIMAL(10,2) NOT NULL | Tax Not Taken |
| 95 | TAX_QTD | Signed Number(12,2) | DECIMAL(10,2) NOT NULL | Tax QTD |
| 96 | TAX_QTD_ADJ | Signed Number(12,2) | DECIMAL(10,2) NOT NULL | Tax QTD Adjusted |
| 97 | TAX_RT | Signed Number(8,6) | DECIMAL(6,6) NOT NULL | Tax Rate (after form) |
| 98 | TAX_RT_NOFORM | Signed Number(8,6) | DECIMAL(6,6) NOT NULL | Tax Rate(before form received) |
| 99 | TAX_YEAR | Signed Number(5,0) | DECIMAL(4) NOT NULL | Tax Year |
| 100 | TAX_YTD | Signed Number(12,2) | DECIMAL(10,2) NOT NULL | Tax YTD |
| 101 | TAX_YTD_ADJ | Signed Number(12,2) | DECIMAL(10,2) NOT NULL | Tax YTD Adjusted |
| 102 | TIPS_ADJ | Signed Number(12,2) | DECIMAL(10,2) NOT NULL | Tip Adjustment |
| 103 | BALANCE_ID | Character(2) | VARCHAR2(2) NOT NULL | Balance ID |
| 104 | SDI_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
SDI Status
E=Exempt N=Not Applicable V=Voluntary Disability Plan Y=Subject |
| 105 | WAGE_PLAN_CD | Character(1) | VARCHAR2(1) NOT NULL |
Wage Plan Code
A=None/State J=State/Exempt L=Voluntary/Exempt P=None/None R=DI Exempt/State S=State/State U=Voluntary/State |
| 106 | WAGE_ADDN_CD | Character(2) | VARCHAR2(2) NOT NULL |
Wage Addition
05=Rooms and/or meals 10=Vehicle Allowance 15=Tips/Gratuities 20=Other |
| 107 | LOCALITY | Character(10) | VARCHAR2(10) NOT NULL | Locality |
| 108 | OFF_CYCLE | Character(1) | VARCHAR2(1) NOT NULL | Off Cycle ? |
| 109 | PAYGROUP | Character(3) | VARCHAR2(3) NOT NULL | Pay Group |
| 110 | RESIDENT | Character(1) | VARCHAR2(1) NOT NULL | Resident |
| 111 | TIPS_ADJUST | Character(1) | VARCHAR2(1) NOT NULL | Adjust to Minimum Wage |
| 112 | TIPS_CATEGORY | Character(1) | VARCHAR2(1) NOT NULL |
Tips Category
A=Tip Allocation C=Tip Credit G=Compulsory Gratuity N=Not Tips R=Reported Tips S=Other Sys Calc'd Tips T=Tippable |
| 113 | TIPS_CUR | Signed Number(12,2) | DECIMAL(10,2) NOT NULL | Current Tips subject to tax |
| 114 | TIPS_DELAYED | Signed Number(12,2) | DECIMAL(10,2) NOT NULL | Current Tips Delayed for W/H |
| 115 | TIPS_MTD | Signed Number(12,2) | DECIMAL(10,2) NOT NULL | MTD Taxable Tips |
| 116 | TIPS_MTD_ADJ | Signed Number(12,2) | DECIMAL(10,2) NOT NULL | MTD Tips Adjusted |
| 117 | TIPS_PROCESSING | Character(1) | VARCHAR2(1) NOT NULL | Tips Processing |
| 118 | AA_PLAN_YR | Number(4,0) | SMALLINT NOT NULL | Aff Action Plan Year |
| 119 | CPI_YR | Number(4,0) | SMALLINT NOT NULL | CPI Adjustment Year |
| 120 | EFF_TAX_YR | Number(4,0) | SMALLINT NOT NULL | Effective Tax Year |
| 121 | HIGH_YR | Number(4,0) | SMALLINT NOT NULL | Highest Year |
| 122 | LOW_YR | Number(4,0) | SMALLINT NOT NULL | Lowest Year |