CA_CHG_TYP2_VW

(SQL View)
 Index Back

Change Reason Codes

User defined reason codes for change packages.

SELECT A.SETID , CHG_TYPE , DESCR20_MIXED FROM PS_CA_CHG_TYPE_TBL A WHERE CHG_TYPE <> 'ACTV' AND EFF_STATUS = 'A' AND EFFDT = ( SELECT MAX(EFFDT) FROM PS_CA_CHG_TYPE_TBL B WHERE A.CHG_TYPE = B.CHG_TYPE AND A.SETID = B.SETID )

  • Related Language Record: CA_CHG_TYP2_LNG

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

    Default Value: OPR_DEF_TBL_FS.SETID

    Prompt Table: SP_SETID_NONVW

    2 CHG_TYPE Character(4) VARCHAR2(4) NOT NULL Change Type is the key to change management functionality. It dictates which fields will be ungrayed and available for edit. This is a key to CA_CHG_TMPL, the change template.
    CTRL=Contract Activated
    3 DESCR20_MIXED Character(20) VARCHAR2(20) NOT NULL Description 20 characters, mixed case