GVT_SCHED_DEFN

(SQL Table)
 Index Back

Schedule Definition

Define Schedule for Bulk/SPS file

  • Related Language Record: GVT_SCHED_DEFNL

  • Parent Record Of GVT_SCHED_GROUP GVT_SCHED_REF

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 GVT_SCHED_PREFIX Character(10) VARCHAR2(10) NOT NULL Schedule Prefix represents user defined part of the Schedule Number. Schedule Number uniquely identifies each schedule and it is combination of Schedule Prefix, Schedule Code and Schedule Sequence.
    2 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    3 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description
    4 GVT_SUMM_SCHED Character(1) VARCHAR2(1) NOT NULL Summary Schedule

    Y/N Table Edit

    5 RUN_ID Character(10) VARCHAR2(10) NOT NULL Pay Run ID

    Prompt Table: GVT_PAY_RUNIDVW

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

    Prompt Table: COMPANY_TBL

    7 GVT_ECS_RFC_INDIC Character(3) VARCHAR2(3) NOT NULL Regional Finance Center
    AFC=Austin Finance Center
    BFC=Birmingham Finance Center
    CFC=Chicago Finance Center
    KFC=Kansas City Finance Center
    PFC=Philadelphia Finance Center
    SFC=San Francisco Finance Center

    Default Value: KFC

    8 GVT_SCHED_STATUS Character(1) VARCHAR2(1) NOT NULL Schedule Process Status
    0=Initial
    1=Pay Check Data Extracted
    2=Schedule Sequence Generated
    3=Bulk File Generated
    4=SPS File Generated
    5=Completed

    Default Value: 0