GVT_SF50_RK_VW

(SQL View)
 Index Back

SF50/52 Remarks Table

SF50/52 Remarks view to display All values except phased retirement ones

SELECT GVT_SF50_REMARK , EFFDT , EFF_STATUS , PRINT_PRIORITY , GVT_REMARK_LINE1 , GVT_REMARK_LINE2 , GVT_REMARK_LINE3 , GVT_REMARK_LINE4 , GVT_REMARK_LINE5 , GVT_REMARK_LINE6 , GVT_REMARK_LINE7 , GVT_REMARK_LINE8 , GVT_REMARK_LINE9 , GVT_INSERT_REQD , GVT_IRR_REPORTABLE , GVT_ROST_REMARK FROM PS_GVT_SF50_RK_TBL WHERE GVT_SF50_REMARK NOT IN('M11','M12','M13','M14','M15','M16','M17','M18','M19')

  • 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