BI_FSS_RSN_VW

(SQL View)
 Index Back

Billing FSS Reasn Code VW

Billing FSS Reasn Code VW

SELECT RC.SETID , RC.REASON_CD , RC.DESCR50 FROM PS_REASON_CD RC WHERE RC.REASON_TYPE = '33' AND RC.EFF_STATUS = 'A' AND %EffdtCheck(REASON_CD,RC,%CURRENTDATEIN)

  • Related Language Record: BI_FSS_RSN_LVW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SETID Character(5) VARCHAR2(5) NOT NULL SetID

    Prompt Table: SP_SETID_NONVW
    Set Control Field: BUSINESS_UNIT

    2 REASON_CD Character(10) VARCHAR2(10) NOT NULL Reason Code
    3 DESCR50 Character(50) VARCHAR2(50) NOT NULL Description of length 50