BAS_STMT_TYP_VW

(SQL View)
 Index Back

Statement Type Prompt

Used for SSText as a prompt for Statement Type

SELECT fieldvalue , xlatlongname FROM PSXLATITEM 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: BAS_STMT_TYPLVW

    • # 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 XLATLONGNAME Character(30) VARCHAR2(30) NOT NULL Translate Long Name