FIN_ACCOUNT_IDTRANSACTION_NOLANGUAGE_CDRBI_CHG_POL_LVW(SQL View) |
Index Back |
|---|---|
View for Change PolicyRLR View for Change Policy........................................................ |
| SELECT A.FIN_ACCOUNT_ID , A.TRANSACTION_NO , L.LANGUAGE_CD , L.RBTACTION_NAME FROM PS_RBI_CHNG_POLICY A , PS_RBF_FIN_ACCOUNT B , PS_RBT_ACTION C , PS_RBT_ACTION_LNG L WHERE A.FIN_ACCOUNT_ID = B.FIN_ACCOUNT_ID AND A.MODIFICATION_TYPE = C.RBTACTION_ID AND A.SETID = C.SETID AND C.SETID = L.SETID AND C.RBTACTION_ID = L.RBTACTION_ID |
| # | 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. |
| 3 | LANGUAGE_CD |
Character(3) | VARCHAR2(3) NOT NULL | Language Code |
| 4 | RBTACTION_NAME | Character(30) | VARCHAR2(30) NOT NULL | Action Name |