GVT_RUN_CNTL

(SQL Table)
 Index Back

Federal Run Control

The Pay Calculation Run Control record manages the pay calculation process.

  • Parent Record Of GVT_AGY_RUNCTL GVT_MPA_RUNCTL GVT_SVCDEP_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
    2 RUN_CNTL_ID Character(30) VARCHAR2(30) NOT NULL Run Control ID
    3 RUN_ID Character(10) VARCHAR2(10) NOT NULL Pay Run ID

    Prompt Table: PAY_RUN_TBL

    4 GVT_ECS_CHECK_SCH Character(14) VARCHAR2(14) NOT NULL GVT Treasury Check Schedule

    Prompt Table: GVT_ECS_CHK_VW

    5 GVT_ECS_CHECK_FILE Character(8) VARCHAR2(8) NOT NULL GVT Treasury Check File
    6 GVT_ECS_CHECK_EXT Character(3) VARCHAR2(3) NOT NULL GVT Treasury Check File Ext
    7 GVT_ECS_EFT_SCH Character(14) VARCHAR2(14) NOT NULL GVT Treasury EFT Schedule

    Prompt Table: GVT_ECS_EFT_VW

    8 GVT_ECS_EFT_FILE Character(8) VARCHAR2(8) NOT NULL GVT Treasury EFT File
    9 GVT_ECS_EFT_EXT Character(3) VARCHAR2(3) NOT NULL GVT Treasury EFT File Ext
    10 GVT_ECS_VENMIS_SCH Character(14) VARCHAR2(14) NOT NULL GVT Treasury NEVMIS Schedule

    Prompt Table: GVT_ECS_MISC_VW

    11 GVT_ECS_VENMIS_FIL Character(8) VARCHAR2(8) NOT NULL GVT Treasury VENMIS File
    12 GVT_ECS_VENMIS_EXT Character(3) VARCHAR2(3) NOT NULL GVT Treasury VENMIS Ext
    13 GVT_ECS_VENCHK_SCH Character(14) VARCHAR2(14) NOT NULL VENMIS Check Schedule

    Prompt Table: GVT_ECS_VCHK_VW

    14 GVT_ECS_VENCHK_FIL Character(8) VARCHAR2(8) NOT NULL VENMIS Check File
    15 GVT_ECS_VENCHK_EXT Character(3) VARCHAR2(3) NOT NULL Extension
    16 GVT_PROCESS_BONDS Character(1) VARCHAR2(1) NOT NULL Process Bonds

    Y/N Table Edit

    Default Value: N

    17 GVT_ECS_BOND_FILE Character(8) VARCHAR2(8) NOT NULL GVT Treasury Bond File
    18 GVT_ECS_BOND_EXT Character(3) VARCHAR2(3) NOT NULL GVT Treasury Bond Ext
    19 GVT_FRB_MEDIA_TYPE Character(1) VARCHAR2(1) NOT NULL FRB Media Type
    D=Diskette
    T=Tape, Cartridge, Electronic

    Default Value: D

    20 GVT_FRB_INCLUD_BDH Character(1) VARCHAR2(1) NOT NULL Include Bulk Data Header

    Y/N Table Edit

    Default Value: N

    21 GVT_FRB_BD_APPL_ID Character(4) VARCHAR2(4) NOT NULL FRB Bulk Data File Appl ID
    22 GVT_FRB_BD_BLKSIZE Character(5) VARCHAR2(5) NOT NULL FRB Bulk Data File BLKSIZE

    Default Value: 320

    23 GVT_FRB_BD_EXTRA Character(31) VARCHAR2(31) NOT NULL FRB Bulk Data Extra Filler
    24 GVT_FRB_BD_FILE_P Character(2) VARCHAR2(2) NOT NULL FRB Bulk Data File Priority

    Default Value: 03

    25 GVT_FRB_BD_FILE_T Character(1) VARCHAR2(1) NOT NULL FRB Bulk Data File Type

    Default Value: 1

    26 GVT_FRB_BD_LRECL Character(5) VARCHAR2(5) NOT NULL FRB Bulk Data File LRECL

    Default Value: 320

    27 GVT_FRB_REC_ABA Character(9) VARCHAR2(9) NOT NULL FRB Receiving ABA

    Default Value: 043000300

    28 GVT_FRB_SEND_ABA Character(9) VARCHAR2(9) NOT NULL FRB Sending ABA

    Default Value: 000000505

    29 FROMDATE Date(10) DATE From Date
    30 THRUDATE Date(10) DATE End Date
    31 GVT_FY_FROMDATE Date(10) DATE Fiscal Year From Date
    32 GVT_FY_THRUDATE Date(10) DATE Fiscal Year Thru Date
    33 GVT_S113_ATH_CEIL Number(7,0) INTEGER NOT NULL SF-113G Authorized Ceiling

    Default Value: 0

    34 COMPANY Character(3) VARCHAR2(3) NOT NULL Company

    Default Value: INSTALLATION.COMPANY

    Prompt Table: COMPANY_TBL

    35 ASOFDATE Date(10) DATE As of Date

    Default Value: %date

    36 GVT_PAY_FROMDATE Date(10) DATE Payroll From Date
    37 GVT_PAY_THRUDATE Date(10) DATE Payroll Thru Date

    Default Value: %date

    38 GVT_TSP_SEQ_YR Number(2,0) SMALLINT NOT NULL TSP Voucher Number
    39 GVT_TSP_SEQ_NO Number(4,0) SMALLINT NOT NULL Voucher Seq No

    Prompt Table: GVT_TSP_VCH_VW

    40 GVT_TSP_INT_FILE Character(12) VARCHAR2(12) NOT NULL Interface File Name
    41 GVT_PAY_PERIOD_CD Character(3) VARCHAR2(3) NOT NULL RITS Interface Pay Period Code
    42 GVT_ORIGINAL_SUPP Character(1) VARCHAR2(1) NOT NULL RITS Interface Original/Supp
    I=Original
    S=Supplemental
    43 GVT_2812_FILE Character(12) VARCHAR2(12) NOT NULL RITS 2812 Interface File Name
    44 GVT_TSP_RPT_ONLY Character(1) VARCHAR2(1) NOT NULL Reprint TSP Voucher Only

    Y/N Table Edit

    Default Value: N

    45 CALENDAR_YEAR Number(4,0) SMALLINT NOT NULL Calendar Year
    46 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    47 LANGUAGE_OPTION Character(1) VARCHAR2(1) NOT NULL Language Option
    O=Specified Language
    R=Recipient's Language
    48 SERVICE_YEARS Number(2,0) SMALLINT NOT NULL Years of Service
    49 POS_ACTIVE_OPTION Character(1) VARCHAR2(1) NOT NULL Pos Active,Inactive,Both Optn
    1=Active
    2=Inactive
    3=Both Active and Inactive
    50 POS_EXCEPT_OVRRIDE Character(1) VARCHAR2(1) NOT NULL Position Exception Override
    E=Exception
    O=Override
    51 POS_REPORT_LEVEL Number(2,0) SMALLINT NOT NULL Pos Hierarchy Report Level
    52 POS_VACANT_REQUEST Character(1) VARCHAR2(1) NOT NULL Request for Vacant Pos Report
    1=Run Vacant Budgeted Positn Rpt
    2=Create Requistn for Vacant Pos
    53 POSITION_NBR Character(8) VARCHAR2(8) NOT NULL Position Number

    Prompt Table: POSITION_DATA

    54 JOB_EFFDT Date(10) DATE Job Effective Date
    55 JOB_REQ_NBR Character(6) VARCHAR2(6) NOT NULL Job requisition number
    56 JOBCODE Character(6) VARCHAR2(6) NOT NULL Job Code
    57 RQMTS_SRCH_NBR Character(6) VARCHAR2(6) NOT NULL Requirements Search #
    58 REPORT_CHOICE Character(1) VARCHAR2(1) NOT NULL Output Report Choice
    1=Applicants
    2=Current Employees
    3=Both Applicants and Employees
    59 BUDGET_START_DT Date(10) DATE Budget Period Start Date
    60 SAL_ADMIN_PLAN Character(4) VARCHAR2(4) NOT NULL Salary Administration Plan

    Prompt Table: GVT_SAL_PLN_VW

    61 INCR_END_DT Date(10) DATE End Date for Step Increments
    62 INCR_START_DT Date(10) DATE Start Date for Step Increments
    63 PAYGROUP Character(3) VARCHAR2(3) NOT NULL Pay Group

    Prompt Table: PAYGROUP_TBL

    64 PERCENTCHG Number(8,2) DECIMAL(7,2) NOT NULL Calculation Percent
    65 AMOUNTCHG Number(8,2) DECIMAL(7,2) NOT NULL Amount of Salary Change
    66 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

    Prompt Table: PERS_SRCH_GBL

    67 INCIDENT_NBR Character(8) VARCHAR2(8) NOT NULL Incident Number

    Prompt Table: INCIDENT_DATA

    68 AD_ANNUALRT Character(1) VARCHAR2(1) NOT NULL Audit Annual Rate

    Y/N Table Edit

    69 AD_CHANGEAMT Character(1) VARCHAR2(1) NOT NULL Audit Change Amount

    Y/N Table Edit

    70 AD_CHANGEPCT Character(1) VARCHAR2(1) NOT NULL Audit Change Percentage

    Y/N Table Edit

    71 AD_COMPRATE Character(1) VARCHAR2(1) NOT NULL Audit Comprate

    Y/N Table Edit

    72 AD_GRADE Character(1) VARCHAR2(1) NOT NULL Audit Grade

    Y/N Table Edit

    73 AD_GRADE_ENTRY_DT Character(1) VARCHAR2(1) NOT NULL Audit Grade Entry Date

    Y/N Table Edit

    74 AD_HOURLYRT Character(1) VARCHAR2(1) NOT NULL Audit Hourly Rate

    Y/N Table Edit

    75 AD_MONTHLYRT Character(1) VARCHAR2(1) NOT NULL Audit Monthly Rate

    Y/N Table Edit

    76 AD_SALADMIN_PLN Character(1) VARCHAR2(1) NOT NULL Audit Salary Admin Plan

    Y/N Table Edit

    77 AD_STEP Character(1) VARCHAR2(1) NOT NULL Audit Step

    Y/N Table Edit

    78 AD_STEP_ENTRY_DT Character(1) VARCHAR2(1) NOT NULL Audit Step Entry Date

    Y/N Table Edit

    79 EEO_RPT_TYPE Character(30) VARCHAR2(30) NOT NULL EEO Report Type
    80 GVT_PAY_PLAN Character(2) VARCHAR2(2) NOT NULL Pay Plan

    Prompt Table: GVT_PAY_PLAN

    81 SALARY_MATRIX_CD Character(5) VARCHAR2(5) NOT NULL Salary Matrix Code

    Prompt Table: SAL_MATRIX_TBL

    82 EXCHNG_TO_CURRENCY Character(3) VARCHAR2(3) NOT NULL To Currency

    Default Value: INSTALLATION.EXCHNG_TO_CURRENCY

    83 STD_HRS_DEFAULT Number(7,2) DECIMAL(6,2) NOT NULL Default Standard Hours

    Default Value: INSTALLATION.STD_HRS_DEFAULT

    84 STD_HRS_FREQUENCY Character(5) VARCHAR2(5) NOT NULL Standard Work Period

    Default Value: INSTALLATION.STD_HRS_FREQUENCY

    85 GVT_HR_FILENAME Character(128) VARCHAR2(128) NOT NULL HR Filename of OPM Tables
    86 GVT_HR_FILENAME2 Character(128) VARCHAR2(128) NOT NULL HR Filename of OPM Tables
    87 GVT_RUN_MODE Character(1) VARCHAR2(1) NOT NULL Run Mode for Government Apps
    L=Load GSA File - Mark Loc Codes
    R=Reset and Mark Loc Codes
    88 GVT_START_COL Character(4) VARCHAR2(4) NOT NULL Column Where Field Starts

    Default Value: 1

    89 GVT_WAGE_FLAG Character(1) VARCHAR2(1) NOT NULL Federal Wage System Flag

    Y/N Table Edit

    Default Value: N

    90 GVT_AUDIT_ANNL_RT Character(1) VARCHAR2(1) NOT NULL Audit Annual Rate

    Y/N Table Edit

    Default Value: N

    91 GVT_AUDIT_BIWK_RT Character(1) VARCHAR2(1) NOT NULL Audit Biweekly Rate

    Y/N Table Edit

    Default Value: N

    92 GVT_AUDIT_CHNG_AMT Character(1) VARCHAR2(1) NOT NULL Audit Change Amount

    Y/N Table Edit

    Default Value: N

    93 GVT_AUDIT_CHNG_PCT Character(1) VARCHAR2(1) NOT NULL Audit Change PerCent

    Y/N Table Edit

    Default Value: N

    94 GVT_AUDIT_COMPRATE Character(1) VARCHAR2(1) NOT NULL Audit Comprate

    Y/N Table Edit

    Default Value: N

    95 GVT_AUDIT_GRADE Character(1) VARCHAR2(1) NOT NULL Audit Grade Changes

    Y/N Table Edit

    Default Value: N

    96 GVT_AUDIT_GRD_DT Character(1) VARCHAR2(1) NOT NULL Audit Grade Entry Date Changes

    Y/N Table Edit

    Default Value: N

    97 GVT_AUDIT_HRLY_RT Character(1) VARCHAR2(1) NOT NULL Audit Hourly_Rt

    Y/N Table Edit

    Default Value: N

    98 GVT_AUDIT_MONTH_RT Character(1) VARCHAR2(1) NOT NULL Audit Monthly Rate

    Y/N Table Edit

    Default Value: N

    99 GVT_AUDIT_STEP Character(1) VARCHAR2(1) NOT NULL Audit Step Changes

    Y/N Table Edit

    Default Value: N

    100 GVT_AUDIT_STP_DT Character(1) VARCHAR2(1) NOT NULL Audit Step Entry Date

    Y/N Table Edit

    Default Value: N

    101 GVT_AUDIT_SAL_PLAN Character(1) VARCHAR2(1) NOT NULL Audit Pay Table Changes

    Y/N Table Edit

    Default Value: N

    102 GVT_ANNUAL_RPT Character(1) VARCHAR2(1) NOT NULL Print Annual Format

    Y/N Table Edit

    Default Value: N

    103 GVT_MONTHLY_RPT Character(1) VARCHAR2(1) NOT NULL Print Monthly Format

    Y/N Table Edit

    Default Value: N

    104 GVT_BIWEEKLY_RPT Character(1) VARCHAR2(1) NOT NULL Print Biweekly Format

    Y/N Table Edit

    Default Value: N

    105 GVT_HOURLY_RPT Character(1) VARCHAR2(1) NOT NULL Print Hourly Format

    Y/N Table Edit

    Default Value: N

    106 GVT_SUB_AGENCY Character(2) VARCHAR2(2) NOT NULL Sub-Agency
    107 GVT_OCC_SERIES Character(4) VARCHAR2(4) NOT NULL Occupational Series
    108 GVT_OCC_SERIES_HGH Character(4) VARCHAR2(4) NOT NULL Occ Series Upper Bound
    109 GVT_OCC_SERIES_LOW Character(4) VARCHAR2(4) NOT NULL Occ Series Lower Bound
    110 GVT_PATCOB_CD Character(1) VARCHAR2(1) NOT NULL PATCOB Code
    1=Exception 1
    2=Exception 2
    3=Exception 3
    4=Exception 4
    5=Exception 5
    6=Exception 6
    7=Exception 7
    8=Exception 8
    A=Administrative
    B=Blue Collar
    C=Clerical
    M=Mixed Collar
    O=Other White Collar
    P=Professional
    T=Technical
    111 GVT_AUDIT_JOBCODE Character(1) VARCHAR2(1) NOT NULL Audit Job Code

    Y/N Table Edit

    112 MANAGER_LEVEL Character(2) VARCHAR2(2) NOT NULL Manager Level
    0=Chief Operating Officer
    1=Director
    2=Senior Officer
    3=Vice President
    4=Senior Manager
    5=Mid-Level Manager
    6=First-Line Manager
    7=Supervisor
    8=All Other Positions
    9=Non-Manager
    113 GRADE Character(3) VARCHAR2(3) NOT NULL Salary Grade
    114 GVT_OUTDEST Character(127) VARCHAR2(127) NOT NULL GVT Output Destination
    115 GVT_OUTTYPE Character(1) VARCHAR2(1) NOT NULL GVT Output Type
    1=Printer
    2=File
    3=Window
    116 GVT_PROC_ALL Character(1) VARCHAR2(1) NOT NULL Process All OPM Codes
    117 GVT_PROC_INUSE_CD Character(1) VARCHAR2(1) NOT NULL Process Agency InUse Codes
    118 GVT_PROC_LEO Character(1) VARCHAR2(1) NOT NULL Process LEO Area Codes

    Prompt Table: GVT_LEOAREA_TBL

    119 GVT_PROC_LOC Character(2) VARCHAR2(2) NOT NULL Process Locality Area Code

    Prompt Table: GVT_LOCAREA_TBL

    120 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country
    121 STATE Character(6) VARCHAR2(6) NOT NULL State

    Prompt Table: STATE_NAMES_TBL

    122 GVT_COUNTY_CD Character(3) VARCHAR2(3) NOT NULL County Code/Name

    Prompt Table: GVT_COUNTY_TBL

    123 GVT_PRINT_NOTE Character(1) VARCHAR2(1) NOT NULL GVT Print Note, Form, Other.

    Default Value: N

    124 GVT_CPDF_DYNAMIC Character(1) VARCHAR2(1) NOT NULL CPDF Dynamic File

    Y/N Table Edit

    125 GVT_CPDF_RUN_DT Date(10) DATE Run Date
    126 GVT_CPDF_STATUS Character(1) VARCHAR2(1) NOT NULL CPDF Status File

    Y/N Table Edit

    127 ACTION Character(3) VARCHAR2(3) NOT NULL Action

    Prompt Table: ACTION_TBL

    128 MOC_ID Character(5) VARCHAR2(5) NOT NULL Mass Organization Change ID

    Prompt Table: GVT_MOC_DATA_VW
    Set Control Field: BUSINESS_UNIT

    129 DELETE_DATA Character(1) VARCHAR2(1) NOT NULL Clear Data in Temp Table
    130 GVT_WIP_STATUS Character(3) VARCHAR2(3) NOT NULL Work-in-Progress Status

    Default Value: PRO

    Prompt Table: GVT_WIP_STATUS

    131 DEPTID Character(10) VARCHAR2(10) NOT NULL Department
    132 POPULATION Character(1) VARCHAR2(1) NOT NULL Search Population-Skill Match
    1=All
    2=Internal Applicants
    3=External Applicants
    4=Candidates for Specific Positn
    133 CAN_OEE_AREACD Character(2) VARCHAR2(2) NOT NULL CEC Management Area
    01=Toronto Management Area
    02=Hamilton Management Area
    03=Niagra Management Area
    04=Brant Haldimand, Norfolk Area
    05=Windsor Management Area
    06=London Management Area
    07=Kitchener Management Area
    08=Mississauga Management Area
    09=Brampton Management Area
    10=York Management Area
    11=Georgian Bay Management Area
    12=Kenora Management Area
    13=Timmins Management Area
    14=Slt.St.Marie Management Area
    15=Sudbury Management Area
    16=North Bay Management Area
    17=Pembroke Management Area
    18=Ottawa Management Area
    19=Cornwall Management Area
    20=Kingston Management Area
    21=Belleville Management Area
    22=Peterborough Management Area
    23=Oshawa Management Area
    134 SCHED_ID Character(6) VARCHAR2(6) NOT NULL Schedule ID
    135 FORM_ID Character(6) VARCHAR2(6) NOT NULL Form Identification
    136 NDT_REPORT_TYPE Character(1) VARCHAR2(1) NOT NULL NDT Report Type
    K=401(k) Report Test Type
    M=401(m) Report Test Type
    137 NDT_TEST_TYPE Character(1) VARCHAR2(1) NOT NULL NDT Test Type
    1=Standard NDT
    2=Section 129 NDT
    3=Section 129 NDT by SLOB
    138 REPRINT_PROMPT Character(1) VARCHAR2(1) NOT NULL Reprint
    139 PRINT_ID Character(6) VARCHAR2(6) NOT NULL Print ID
    140 COST_FREQUENCY Character(1) VARCHAR2(1) NOT NULL Cost Freq on Enrollment Form
    A=Annual Frequency
    D=Deduction Frequency
    141 REPORTING_PERIOD Character(1) VARCHAR2(1) NOT NULL Reporting Period
    M=Monthly
    Q=Quarterly
    142 PLAN_TYPE Character(2) VARCHAR2(2) NOT NULL Identifies a category of benefit plan, such as Medical, Dental, and Life (Insurance). A set of plan type codes, as well as rules for creating new codes, is provided by PeopleSoft. Plan Type codes determine how the system processes and defines eligibility for the various benefit plans.
    143 VENDOR_SETID Character(5) VARCHAR2(5) NOT NULL Vendor Set ID
    144 VENDOR_ID Character(10) VARCHAR2(10) NOT NULL Vendor Identifier
    145 INCL_OPTN_DETAIL Character(1) VARCHAR2(1) NOT NULL Include Option Detail
    146 BAS_FORM_TYPE Character(1) VARCHAR2(1) NOT NULL Benefits Admin Form Type
    C=Confirmation Statement
    E=Enrollment Form
    147 PROCESS_STATUS_AE Character(1) VARCHAR2(1) NOT NULL Assign Error
    148 PROCESS_STATUS_AN Character(1) VARCHAR2(1) NOT NULL Assign None
    149 PROCESS_STATUS_AS Character(1) VARCHAR2(1) NOT NULL Assigned
    150 PROCESS_STATUS_EE Character(1) VARCHAR2(1) NOT NULL Election Error
    151 PROCESS_STATUS_ET Character(1) VARCHAR2(1) NOT NULL Elections Entered
    152 PROCESS_STATUS_FA Character(1) VARCHAR2(1) NOT NULL Finalized - Benefit Pgm None
    153 PROCESS_STATUS_FE Character(1) VARCHAR2(1) NOT NULL Finalized - Enrolled
    154 PROCESS_STATUS_FP Character(1) VARCHAR2(1) NOT NULL Finalized - Prepare None
    155 PROCESS_STATUS_NT Character(1) VARCHAR2(1) NOT NULL Notified
    156 PROCESS_STATUS_PE Character(1) VARCHAR2(1) NOT NULL Prepare Error
    157 PROCESS_STATUS_PR Character(1) VARCHAR2(1) NOT NULL Prepared
    158 PROCESS_STATUS_RE Character(1) VARCHAR2(1) NOT NULL Re-Enter
    159 JOB_ELIG_CHG Character(1) VARCHAR2(1) NOT NULL Job Eligibility Changed
    160 ADDR_ELIG_CHG Character(1) VARCHAR2(1) NOT NULL Address Eligibility Changed
    161 BAS_EVT_DISCONNECT Character(1) VARCHAR2(1) NOT NULL Event Disconnected
    162 BAS_EVENT_CHG Character(1) VARCHAR2(1) NOT NULL Event Out of Sequence
    163 INCL_SUMMARY Character(1) VARCHAR2(1) NOT NULL Include Summary
    164 BENEFIT_PROGRAM Character(3) VARCHAR2(3) NOT NULL Defines a collection of benefit plans and their associated rate and calculation rules.
    165 NEW_BENPROGRAM Character(3) VARCHAR2(3) NOT NULL New Benefit Program
    166 ELIG_RULES_ID Character(4) VARCHAR2(4) NOT NULL Eligibility Rules ID
    167 EVENT_RULES_ID Character(4) VARCHAR2(4) NOT NULL Event Rules ID
    168 CLAIMID Character(8) VARCHAR2(8) NOT NULL Claim ID
    169 FSA_ACCT_CLOSURE Character(1) VARCHAR2(1) NOT NULL FSA Account Closre
    170 FMLA_PLAN_ID Character(3) VARCHAR2(3) NOT NULL Family Medical Leave Plan ID
    171 BILL_PER_CD Character(4) VARCHAR2(4) NOT NULL Billing Period
    172 EE_REPORT_YEAR Number(4,0) SMALLINT NOT NULL Empl Equity Reporting Year
    173 FORM_DATE Date(10) DATE Benefits Admin Form Date
    174 CURR_EFFDT Date(10) DATE Current Benefit Program Effdt
    175 NEW_EFFDT Date(10) DATE New Benefit Program Effdt
    176 CHECK_DT Date(10) DATE Check date.
    177 PAYCHECK_NBR Number(15,0) DECIMAL(15) NOT NULL Paycheck number.
    178 FMLA_RPTG_WEEKS Number(2,0) SMALLINT NOT NULL Leaves Completed Report Weeks
    179 RPT_DETAIL_LEVEL Character(1) VARCHAR2(1) NOT NULL Level of Report Detail
    C=Claim-Level Detail
    D=Line-Item Detail Level
    R=Summary by Selection
    S=Detail Report
    180 BENEFIT_RCD_NBR Number(3,0) SMALLINT NOT NULL Specifies a sequence number associated with each of multiple concurrent jobs for a one employee. It is used to determine the applicable benefit program for each job. The first job entered for an employee is automatically assigned a Benefit Record Number of zero (0). This field is linked with EMPL_RCD#, the Employment Record Number.
    181 EVENT_ID Number(6,0) INTEGER NOT NULL Event Identification
    182 GVT_CPDF_VAL_STAT Character(1) VARCHAR2(1) NOT NULL Validate CPDF Status Data

    Y/N Table Edit

    183 GVT_CPDF_VAL_DYN Character(1) VARCHAR2(1) NOT NULL Validate CPDF Dynamic Data

    Y/N Table Edit

    184 GVT_NEXT_PAY_ADJ Date(10) DATE GVT Next Scheduled Pay Adjust
    185 GVT_STATUS_ACCT Character(3) VARCHAR2(3) NOT NULL Status Account
    1=Open
    2=Cancelled
    3=Closed
    186 GVT_PRTALL_1514 Character(1) VARCHAR2(1) NOT NULL Print All Status 1514 Reports

    Y/N Table Edit

    Default Value: N

    187 IDP_DATE Date(10) DATE IDP Date
    188 SETID Character(5) VARCHAR2(5) NOT NULL SetID

    Prompt Table: SETID_TBL

    189 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
    190 RUNDATE Date(10) DATE Process Scheduler Run Date

    Default Value: %date

    191 GVT_INCL_OFF_DED Character(1) VARCHAR2(1) NOT NULL Used to detrmine if eligible Off Cycle Deductions are included in interface processes

    Y/N Table Edit

    192 GVT_INCL_OFF_NET Character(1) VARCHAR2(1) NOT NULL Used to detrmine if eligible Off Cycle Net Pay is included in interface processes

    Y/N Table Edit

    193 BENEFIT_PLAN Character(6) VARCHAR2(6) NOT NULL Benefit Plan

    Prompt Table: GVT_BEN_PLN_VW

    194 ALL_BENEFIT_PLAN Character(1) VARCHAR2(1) NOT NULL Select All Benefit Plans

    Y/N Table Edit

    195 GVT_CLER_TYPE Character(1) VARCHAR2(1) NOT NULL Indicates how to process the Clearinghouse file. I=Initial, A=Add, R=replace. This field is put into the header record of the CLER interface file.
    A=Add to Existing File
    I=Initial File
    R=Replace File

    Default Value: I

    196 GVT_CPDF_VAL_ONLNE Character(1) VARCHAR2(1) NOT NULL CPDF Online Validation

    Y/N Table Edit

    Default Value: N

    197 EFFSEQ Number(3,0) SMALLINT NOT NULL Effective Sequence
    198 EFFDT Date(10) DATE Effective Date
    199 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Rcd Nbr
    200 SEQ_NO Number(2,0) SMALLINT NOT NULL Sequence Number
    201 PROCESS_ON_OFF Character(1) VARCHAR2(1) NOT NULL Process On-Cycle or Off-Cycle
    F=Process Off-Cycle Checks
    O=Process On-Cycle Checks

    Default Value: O

    202 GVT_CLER_PAY_CYCLE Character(1) VARCHAR2(1) NOT NULL Indicates the pay cycle for the Clearinghouse file. B=Biweekly, M=Monthly, O=Other. This field is put into the header record of the CLER interface file.
    B=Biweekly
    M=Monthly
    O=Other

    Default Value: O