GVT_ECS_REMARKS

(SQL Table)
 Index Back

GVT ECS Schedule Remarks Info

Used to track the assigning and usage of the ECS Schedule Number Remarks by count for each Summary Schedule. Note that there are edits concerning the number entries on this table based on Schedule type

  • Related Language Record: GVT_ECS_REM_LNG

  • Parent record: GVT_ECS_CONTROL

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 COMPANY Character(3) VARCHAR2(3) NOT NULL Company

    Prompt Table: COMPANY_TBL

    2 GVT_SCHEDULE_NO Character(14) VARCHAR2(14) NOT NULL Schedule Number

    Prompt Table: GVT_ECS_CONTROL

    3 GVT_ECS_REMARKS_NO Number(2,0) SMALLINT NOT NULL GVT ECS Remarks Line Number

    Default Value: 1

    4 GVT_ECS_REMARKS Character(72) VARCHAR2(72) NOT NULL Govt ECS Remarks