RBI_CHG_POL_VW

(SQL View)
 Index Back

View for Change Policy

View for Change Policy..........................................................

SELECT A.FIN_ACCOUNT_ID , A.TRANSACTION_NO , C.RBTACTION_NAME , A.SETID , A.RC_BS_INSTANCE , A.FORM_INSTANCE_ID , A.DESCRLONG FROM PS_RBI_CHNG_POLICY A , PS_RBF_FIN_ACCOUNT B , PS_RBT_ACTION C WHERE A.FIN_ACCOUNT_ID = B.FIN_ACCOUNT_ID AND A.MODIFICATION_TYPE = C.RBTACTION_ID AND A.SETID = C.SETID

  • Related Language Record: RBI_CHG_POL_LVW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 FIN_ACCOUNT_ID Character(20) VARCHAR2(20) NOT NULL Financial Account Number
    2 TRANSACTION_NO Character(15) VARCHAR2(15) NOT NULL Transaction table's primary key.

    Default Value: NEXT

    3 RBTACTION_NAME Character(30) VARCHAR2(30) NOT NULL Action Name
    4 SETID Character(5) VARCHAR2(5) NOT NULL This field is used to store the value of SetID on various setup tables.
    5 RC_BS_INSTANCE Number(15,0) DECIMAL(15) NOT NULL RC_BS_INSTANCE
    6 FORM_INSTANCE_ID Number(15,0) DECIMAL(15) NOT NULL Instance ID
    7 DESCRLONG Long Character CLOB Long Description