Docstoc

MDC Allocations

Document Sample
MDC Allocations Powered By Docstoc
					PAYROLL FUNDING                                 MDC_ALLOCATIONS                                       REVISED: 11/09/2009


FIELD NAME         TYPE   START POS        RAW LENGTH MASK    FORMAT DESCRIPTION                          KEY
RECORD_NAME        Char                1             8      8 Upper Value: MDCALLOC                        *
SSN                Char                9             9      9        Social Security Number                *
PROCESS_INSTANCE   Nbr                18            10     10        Process Instance Number               *
SEQNUM             Nbr                28             3      3        Sequence Number
LINE_NBR           Nbr                31             8      8        Line Number
COMPANY            Char               39             3      3 Upper Company
PAYGROUP           Char               42             3      3 Upper Pay Group
PAY_END_DT         Date               45            10     10        Pay Period End Date
OFF_CYCLE          Char               55             1      1 Upper Off Cycle
PAGE_NUM           Nbr                56             4      4        Page Number
LINE_NUM           Nbr                60             2      2        Line Number
SEPCHK             Nbr                62             1      1        Sep Chk #
ERNCD              Char               63             3      3 Upper Earnings Code
STATE              Char               66             6      6 Upper State
LOCALITY           Char               72             1      1 Upper Locality
TAX_CLASS          Char               73             1      1 Upper Tax Balance Class
TAX_CLASS          Char               73             1      1  Value Description
TAX_CLASS          Char               73             1      1    A   Non-resident alien (1042)
TAX_CLASS          Char               73             1      1    B   Local - Employer and Employee
TAX_CLASS          Char               73             1      1    C   Earned Income Credit
TAX_CLASS          Char               73             1      1    D   OASDI/Disability - EE
TAX_CLASS          Char               73             1      1    E   OASDI/Disability - ER
TAX_CLASS          Char               73             1      1    F   FICA Med Hospital Ins / EE
TAX_CLASS          Char               73             1      1    G   OASDI/EE - tips
TAX_CLASS          Char               73             1      1    H   Withholding
TAX_CLASS          Char               73             1      1    J   OASDI/ER - tips
TAX_CLASS          Char               73             1      1    K   Excise
TAX_CLASS          Char               73             1      1    L   NJ Supl Workforce Admin Fund
TAX_CLASS          Char               73             1      1   M    New Jersey WDPF
TAX_CLASS          Char               73             1      1    N   New Jersey HCSF
TAX_CLASS          Char               73             1      1    P   Occupational Privilege Tax
TAX_CLASS          Char               73             1      1    Q   FICA Med Hospital Ins / ER
TAX_CLASS          Char               73             1      1    R   Local ER
TAX_CLASS          Char               73             1      1    S   Unemployment - Special
TAX_CLASS          Char               73             1      1    T   FICA Med Hospital Ins /EE-tips
TAX_CLASS          Char               73             1      1    U   Unemployment ER
PAYROLL FUNDING                                MDC_ALLOCATIONS                                       REVISED: 11/09/2009


FIELD NAME        TYPE   START POS        RAW LENGTH MASK    FORMAT DESCRIPTION                          KEY
TAX_CLASS         Char               73             1      1    V   Unemployment EE
TAX_CLASS         Char               73             1      1   W    Voluntary Disability Plan EE
TAX_CLASS         Char               73             1      1    X   Voluntary Disability Plan ER
TAX_CLASS         Char               73             1      1    Z   FICA Med Hospital Ins /ER-tips
PLAN_TYPE         Char               74             2      2 Upper Plan Type
PLAN_TYPE         Char               74             2      2  Value Description
PLAN_TYPE         Char               74             2      2    0   General Deduction
PLAN_TYPE         Char               74             2      2   10   Medical
PLAN_TYPE         Char               74             2      2   11   Dental
PLAN_TYPE         Char               74             2      2   14   Vision
PLAN_TYPE         Char               74             2      2   1Y   Dental - Dependents
PLAN_TYPE         Char               74             2      2   1Z   Medical - Dependents
PLAN_TYPE         Char               74             2      2   20   Life
PLAN_TYPE         Char               74             2      2   21   Supplemental Life
PLAN_TYPE         Char               74             2      2   25   Dependent Life
PLAN_TYPE         Char               74             2      2   27   Supplemental Life - 1st 20000
PLAN_TYPE         Char               74             2      2   2X   Supp Life > $50,000
PLAN_TYPE         Char               74             2      2   30   Short-Term Disability
PLAN_TYPE         Char               74             2      2   47   Nonelective Contributions
PLAN_TYPE         Char               74             2      2   48   Employer Only
PLAN_TYPE         Char               74             2      2   49   Section 457
PLAN_TYPE         Char               74             2      2   4Y   OPERS
PLAN_TYPE         Char               74             2      2   4Z   Administrative Fee
PLAN_TYPE         Char               74             2      2   50   Sick
PLAN_TYPE         Char               74             2      2   51   Vacation
PLAN_TYPE         Char               74             2      2   60   Flex Spending Health - U.S.
PLAN_TYPE         Char               74             2      2   61   Flex Spending Dependent Care
PLAN_TYPE         Char               74             2      2   70   PERS
PLAN_TYPE         Char               74             2      2   7Y   PERS 3
PLAN_TYPE         Char               74             2      2   7Z   PERS 2
PLAN_TYPE         Char               74             2      2   82   Pension Plan 1 - U.S.
BENEFIT_PLAN      Char               76             6      6 Upper Benefit Plan
DEDCD             Char               82             6      6 Upper Deduction Code
DESCRSHORT        Char               88            10     10 Mixed Short Description
DED_CLASS         Char               98             1      1 Upper Deduction Classification
DED_CLASS         Char               99             1      1  Value Description
PAYROLL FUNDING                              MDC_ALLOCATIONS                                      REVISED: 11/09/2009


FIELD NAME         TYPE   START POS    RAW LENGTH MASK    FORMAT DESCRIPTION                          KEY
DED_CLASS          Char           100            1      1    A   After-Tax
DED_CLASS          Char           101            1      1    B   Before-Tax
DED_CLASS          Char           102            1      1    L   QC Taxable Benefit
DED_CLASS          Char           103            1      1    N   Nontaxable Benefit
DED_CLASS          Char           104            1      1    P   Nontaxable Ptax Benefit
DED_CLASS          Char           105            1      1    T   Taxable Benefit
DED_SLSTX_CLASS    Char             99           1      1 Upper Sales Tax Type
DED_SLSTX_CLASS    Char             99           1      1  Value Description
DED_SLSTX_CLASS    Char             99           1      1    B   None
DED_SLSTX_CLASS    Char             99           1      1    G   Goods and Services Tax
DED_SLSTX_CLASS    Char             99           1      1    H   Harmonized Sales Tax
DED_SLSTX_CLASS    Char             99           1      1    I   Provincial Sales Tax Insurance
DED_SLSTX_CLASS    Char             99           1      1    P   Provincial Sales Tax
DED_SLSTX_CLASS    Char             99           1      1    Q   QC Prov Sales Tax Insurance
DED_SLSTX_CLASS    Char             99           1      1    S   QC Prov Sales Tax
DED_SLSTX_CLASS    Char             99           1      1    T   Provincial Premium Tax
DED_SLSTX_CLASS    Char             99           1      1    U   QC Provincial Premium Tax
RUN_ID             Char           100           10     10 Upper Pay Run ID
PAY_BEGIN_DT       Date           110           10     10        Pay Period Begin Date
BUDGET_DT          Date           120           10     10        Budget Date
RUN_DTTM           DtTm           130           26     26 Scnds Run Date and Time
EMPLID             Char           156           11     11 Upper Employee ID
EMPL_RCD           Nbr            167            3      3        Employee Record Number
NAME               Char           170           50     50 Mixed Employee Name
JOBCODE            Char           220            6      6 Upper Job Code
MDC_DIVISION       Char           226           10     10 Mixed Division
BUSINESS_UNIT_GL   Char           236            5      5 Upper General Ledger Business Unit
BUSINESS_UNIT_HR   Char           241            5      5 Upper Business Unit for HRMS
ACCT_CD            Char           246           25     25 Upper Account Code
ACCOUNT            Char           271           10     10 Upper Account
DEPTID             Char           281           10     10 Upper Department
PROJECT_ID         Char           291           15     15 Upper Project ID
PRODUCT            Char           306            6      6 Upper Product
FUND_CODE          Char           312            5      5 Upper Fund Code
PROGRAM_CODE       Char           317            5      5 Upper Program Code
CLASS_FLD          Char           322            5      5 Upper Class Funding Field
PAYROLL FUNDING                                 MDC_ALLOCATIONS                                          REVISED: 11/09/2009


FIELD NAME           TYPE   START POS      RAW LENGTH MASK        FORMAT DESCRIPTION                         KEY
AFFILIATE            Char             327            5          5 Upper Affiliate
OPERATING_UNIT       Char             332            8          8 Upper Operating Unit
ALTACCT              Char             340           10         10 Upper Alternate Account
BUDGET_REF           Char             350            8          8 Upper Budget Reference
CHARTFIELD1          Char             358           10         10 Upper CFDA
CHARTFIELD2          Char             368           10         10 Upper Chartfield 2
CHARTFIELD3          Char             378           10         10 Upper Chartfield 3
MONETARY_AMOUNT      Sign             388           16 +9(12).99         Monetary Amount
HOURS_EARNED         Sign             404           12 +9(4).9(6)        Hours Earned
INCOME_CD_1042       Char             416            2          2   Num  Income Code for 1042-S
INCOME_CD_1042       Char             416            2          2  Value Description
INCOME_CD_1042       Char             416            2          2    12  Royalties
INCOME_CD_1042       Char             416            2          2    15  Scholarship/Fellowship Grants
INCOME_CD_1042       Char             416            2          2    16  Independent Personal Services
INCOME_CD_1042       Char             416            2          2    17  Dependent Personal Services
INCOME_CD_1042       Char             416            2          2    18  Teaching
INCOME_CD_1042       Char             416            2          2    19  Studying and Training
INCOME_CD_1042       Char             416            2          2    50  Other Income
LINE_DESCR           Char             418           20         20 Mixed Journal Line Description
GL_SENT_IND          Char             438            1          1        Sent to GL
ADD_GROSS            Char             439            1          1        Add to Gross Pay
HRS_ONLY             Char             440            1          1        Hours Only
REVERSAL_IND         Nbr              441            1          1        Reversal Indicator
USER_FIELD_1         Char             442           10         10 Upper User Field 1
LOCATION             Char             452           10         10 Upper Location - Warrant Seq Nbr
PAYCHECK_NBR         Char             462           10         10 Upper Paycheck Number
CHECK_DT             Date             472           10         10        Issue Date
POSITION_NBR         Char             482            8          8 Upper Position Number
ADDS_TO_FTE_ACTUAL   Char             490            1          1 Upper Adds To FTE Actual Count
REG_TEMP             Char             491            1          1 Upper Regular/Temporary
FULL_PART_TIME       Char             492            1          1 Upper Full/Part Time
FILLER               Char             493          108        108        Filler
                              Total Length         600

				
DOCUMENT INFO