RBT_BS_CNTCT_VW(SQL View) |
Index Back |
|---|---|
Churn Action HistoryChurn Action History |
| SELECT A.SETID ,A.BO_ID_CONTACT ,A.RC_BS_INSTANCE ,B.SCRIPT_ID ,B.RC_BS_STATUS ,A.RBT_CUST_VALUE ,A.RBT_CHURN_SCORE ,A.ROW_ADDED_OPRID ,A.ROW_ADDED_DTTM FROM PS_RBT_BS_CONTACT A , PS_RC_BS_INSTANCE B WHERE A.RC_BS_INSTANCE = B.RC_BS_INSTANCE |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SETID | Character(5) | VARCHAR2(5) NOT NULL | This field is used to store the value of SetID on various setup tables. |
| 2 | BO_ID_CONTACT | Number(31,0) | DECIMAL(31) NOT NULL | This field indicates the Business Object ID for the contact. |
| 3 | RC_BS_INSTANCE | Number(15,0) | DECIMAL(15) NOT NULL | RC_BS_INSTANCE |
| 4 | SCRIPT_ID | Number(12,0) | DECIMAL(12) NOT NULL | Script ID |
| 5 | RC_BS_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Branch Script Status. It is ether Valid or Invalid.
C=Completed P=Processing S=Started |
| 6 | RBT_CUST_VALUE | Character(30) | VARCHAR2(30) NOT NULL | Customer Value |
| 7 | RBT_CHURN_SCORE | Character(30) | VARCHAR2(30) NOT NULL | CHURN SCORE |
| 8 | ROW_ADDED_OPRID | Character(30) | VARCHAR2(30) NOT NULL | ID of user who added the row. |
| 9 | ROW_ADDED_DTTM | DateTime(26) | TIMESTAMP | This is a datetime field for record creation. |