RCT_BSCRIPT_VW(SQL View) |
Index Back |
|---|---|
Script view |
| SELECT SETID , SCRIPT_ID , EFFDT , EFF_STATUS , SCRIPT_CATEGORY , SCRIPT_TYPE , SCRIPT_NAME FROM PS_RC_BSCRIPT WHERE EFF_STATUS = 'A' AND SCRIPT_TYPE = 'CHRN' |
| # | 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.
Default Value: SHARE Prompt Table: SP_SETID_NONVW |
| 2 | SCRIPT_ID |
Number(12,0) | DECIMAL(12) NOT NULL |
Script ID
Default Value: 999999999999 |
| 3 | EFFDT | Date(10) | DATE NOT NULL | Effective Date |
| 4 | EFF_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Effective Status
A=Active I=Inactive Default Value: A |
| 5 | SCRIPT_CATEGORY | Character(1) | VARCHAR2(1) NOT NULL |
Branch Scripting Category Field
B=Branch Script L=Linear Script Default Value: B |
| 6 | SCRIPT_TYPE | Character(4) | VARCHAR2(4) NOT NULL |
Branch Scripting Type field
CHRN=Churn CORD=Configure Order CQST=Contact Questionnaire CSAT=Customer Satisfaction GUID=Troubleshooting Guide LEAD=Lead Qualification PADV=Product Advisor PAPP=Product Application TELM=TeleSales |
| 7 | SCRIPT_NAME | Character(40) | VARCHAR2(40) NOT NULL | Branch Scripting Name Field |