BAS_STMT_TYPLVW

(SQL View)
 Index Back

Statement Type Prompt

Used for SSText as a prompt for Statement Type

SELECT fieldvalue , language_cd , xlatlongname FROM PSXLATITEMLANG a WHERE fieldname = 'BAS_STMT_TYPE' AND effdt = ( SELECT MAX(effdt) FROM PSXLATITEM b WHERE a.fieldname = b.fieldname AND a.fieldvalue = b.fieldvalue AND b.effdt <= %CurrentDateIn)

  • Related Language Record for BAS_STMT_TYP_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 BAS_STMT_TYPE Character(1) VARCHAR2(1) NOT NULL Benefits Statement Type
    C=Confirmation Statement
    E=Enrollment Preview
    S=Submitted Enrollment

    Default Value: C

    2 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    3 XLATLONGNAME Character(30) VARCHAR2(30) NOT NULL Translate Long Name