UPG_BSCRIPT_AET

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
2	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).
3	RUN_CNTL_ID	Character(30)	VARCHAR2(30) NOT NULL	Run Control ID
4	RC_BS_INSTANCE	Number(15,0)	DECIMAL(15) NOT NULL	RC_BS_INSTANCE
5	EFFSEQ	Number(3,0)	SMALLINT NOT NULL	Effective Sequence
6	SCRIPT_ID	Number(12,0)	DECIMAL(12) NOT NULL	Script ID
7	SETID	Character(5)	VARCHAR2(5) NOT NULL	This field is used to store the value of SetID on various setup tables.
8	EFFDT	Date(10)	DATE	Effective Date
9	RC_QUEST_GRP_ID	Number(12,0)	DECIMAL(12) NOT NULL	Branch script
10	RC_ANSWER_PATH_ID	Number(12,0)	DECIMAL(12) NOT NULL	Answer BS Path ID
11	QUESTION_ID	Number(12,0)	DECIMAL(12) NOT NULL	Used in CRM branch script
12	RC_WEIGHT	Number(8,0)	INTEGER NOT NULL	Branch Scripting Number field
13	BS_OBJECT_ID	Character(80)	VARCHAR2(80) NOT NULL	Object keys
14	RC_ANSWERSET_ID	Number(12,0)	DECIMAL(12) NOT NULL	Answer Set ID for Branch Scripting
15	RC_ANSWER_ID	Number(12,0)	DECIMAL(12) NOT NULL	Answer ID
16	UPG_ANSWER_ID	Character(30)	VARCHAR2(30) NOT NULL	Used for script upgrade purpose
17	ANSWER_VALUE	Character(254)	VARCHAR2(254) NOT NULL	Answer Value
18	BS_SCRIPT_PATH	Character(100)	VARCHAR2(100) NOT NULL	branch script path
19	LANGUAGE_CD	Character(3)	VARCHAR2(3) NOT NULL	Language Code
20	BS_PATH_ID	Number(12,0)	DECIMAL(12) NOT NULL	Branch Script Path ID
21	RC_BS_ANY_FLG	Character(1)	VARCHAR2(1) NOT NULL	Any Branch Y/N Table Edit
22	RC_RULESET_ID	Number(12,0)	DECIMAL(12) NOT NULL	Branch script
23	RC_RULE_ID	Number(12,0)	DECIMAL(12) NOT NULL	Rule Set Name for Branch Scripting
24	SCR_VAR_ID	Number(12,0)	DECIMAL(12) NOT NULL	Branch Scripting Value Field
25	RC_SETID	Character(5)	VARCHAR2(5) NOT NULL	Setid work field ....................................
26	SUB_SCRIPT_ID	Number(12,0)	DECIMAL(12) NOT NULL	Branch script
27	RC_EFFDT	Date(10)	DATE	Branch Script Effective Date
28	RC_BS_PATH_ID	Number(12,0)	DECIMAL(12) NOT NULL	Branch Script Path ID
29	RC_BS_ACTIONSET_ID	Number(12,0)	DECIMAL(12) NOT NULL	Branch script
30	NODE_LEVEL_NUM	Number(3,0)	SMALLINT NOT NULL	Node Level Number
31	RC_SEQ_NBR	Number(3,0)	SMALLINT NOT NULL	Sequence Number
32	RC_SCORE	Number(6,2)	DECIMAL(5,2) NOT NULL	Survey Score
33	ANSWER_ORDER	Number(3,0)	SMALLINT NOT NULL	Answer Sequence
34	SCORE_NUM	Number(3,0)	SMALLINT NOT NULL	Score
35	IS_DEFAULT_FLG	Character(1)	VARCHAR2(1) NOT NULL	Default N=No Y=Yes
36	IS_ENABLED_FLG	Character(1)	VARCHAR2(1) NOT NULL	Enabled N=No Y=Yes
37	PARENT_PATH_ID	Number(12,0)	DECIMAL(12) NOT NULL	Branch Script Path ID
38	BS_ROW_NUM	Number(5,0)	INTEGER NOT NULL	Row Number
39	RC_QUEST_PATH_ID	Number(12,0)	DECIMAL(12) NOT NULL	Question BS Path ID
40	TOTAL_ROW_INSERTED	Number(18,0)	DECIMAL(18) NOT NULL	Used to indicate how many rows are inserted.
41	TOTAL_ROW_TOINSERT	Number(18,0)	DECIMAL(18) NOT NULL	Indicate how many rows to insert
42	ROW_ADDED_OPRID	Character(30)	VARCHAR2(30) NOT NULL	ID of user who added the row.
43	ROW_ADDED_DTTM	DateTime(26)	TIMESTAMP	This is a datetime field for record creation.
44	ROW_LASTMANT_DTTM	DateTime(26)	TIMESTAMP	The date and time that the row was last updated.
45	ROW_LASTMANT_OPRID	Character(30)	VARCHAR2(30) NOT NULL	ID of user who last modified the row.
46	SYNCID	Number(10,0)	DECIMAL(10) NOT NULL	The Synchronization ID field stores a value generated by the sync processor. The value is used to identify the type of object that the sync processor is about to handle.
47	SYNCDTTM	DateTime(26)	TIMESTAMP	Synchronization Last Update Date Time