CA_STATUS_VW

(SQL View)
 Index Back

All Status values


SELECT SETID ,CA_STATUS ,DESCR ,CA_PROC_STATUS ,DEFAULT_FLAG FROM PS_CA_STATUS_TBL

  • Related Language Record: CA_STATUS_LANG

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

    Prompt Table: SP_SETID_NONVW

    2 CA_STATUS Character(24) VARCHAR2(24) NOT NULL Contract Status
    3 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    4 CA_PROC_STATUS Character(1) VARCHAR2(1) NOT NULL CA_STATUS is a user defined status field that maps (many to 1) to the contract Processing Status field. Process Status indicates what change processing is available.
    A=Active
    C=Closed
    P=Pending

    Default Value: P

    5 DEFAULT_FLAG Character(1) VARCHAR2(1) NOT NULL Default

    Y/N Table Edit