GVT_SF50_RK_TBL

(SQL Table)
Index Back

SF50/52 Remarks Table

  • Related Language Record: GVT_SF50_RK_LNG
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 GVT_SF50_REMARK Character(3) VARCHAR2(3) NOT NULL SF50 Remark Code
    2 EFFDT Date(10) DATE NOT NULL Effective Date

    Default Value: %date

    3 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
    A=Active
    I=Inactive

    Default Value: A

    4 PRINT_PRIORITY Character(2) VARCHAR2(2) NOT NULL Used to decide the priority in which the Remarks are printed on the SF50 Report.
    01=1st Tier
    02=2nd Tier

    Default Value: 01

    5 GVT_REMARK_LINE1 Character(72) VARCHAR2(72) NOT NULL Remark Line 1
    6 GVT_REMARK_LINE2 Character(72) VARCHAR2(72) NOT NULL Remark Line 2
    7 GVT_REMARK_LINE3 Character(72) VARCHAR2(72) NOT NULL Remark Line 3
    8 GVT_REMARK_LINE4 Character(72) VARCHAR2(72) NOT NULL Remark Line 4
    9 GVT_REMARK_LINE5 Character(72) VARCHAR2(72) NOT NULL Remark Line 5
    10 GVT_REMARK_LINE6 Character(72) VARCHAR2(72) NOT NULL Remark Line 6
    11 GVT_REMARK_LINE7 Character(72) VARCHAR2(72) NOT NULL Remark Line 7
    12 GVT_REMARK_LINE8 Character(72) VARCHAR2(72) NOT NULL Remark Line 8
    13 GVT_REMARK_LINE9 Character(72) VARCHAR2(72) NOT NULL Remark Line 9
    14 GVT_INSERT_REQD Character(1) VARCHAR2(1) NOT NULL Insertion Required

    Y/N Table Edit

    Default Value: N

    15 GVT_IRR_REPORTABLE Character(1) VARCHAR2(1) NOT NULL IRR Reporting Settings

    Y/N Table Edit

    Default Value: N

    16 GVT_ROST_REMARK Character(1) VARCHAR2(1) NOT NULL ROST Reportable

    Y/N Table Edit

    Default Value: N