RA_BSCRIPT_LANG(SQL View) |
Index Back |
---|---|
Marketing View into ScriptsCampaign Management view into scripts related language |
SELECT C.SETID , C.SCRIPT_ID , C.LANGUAGE_CD , C.SCRIPT_NAME FROM PS_RC_BSCRIPT A , PS_RC_BSCRIPT_LNG C WHERE C.SETID = A.SETID AND C.SCRIPT_ID = A.SCRIPT_ID AND C.EFFDT = A.EFFDT AND A.EFFDT = ( SELECT MAX(EFFDT) FROM PS_RC_BSCRIPT B WHERE A.SETID = B.SETID AND A.SCRIPT_ID = B.SCRIPT_ID AND B.EFFDT <= %CurrentDateIn) |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | Character(5) | VARCHAR2(5) NOT NULL |
This field is used to store the value of SetID on various setup tables.
Prompt Table: SP_SETID_NONVW |
|
2 | Number(12,0) | DECIMAL(12) NOT NULL | Script ID | |
3 | Character(3) | VARCHAR2(3) NOT NULL | Language Code | |
4 | SCRIPT_NAME | Character(40) | VARCHAR2(40) NOT NULL | Branch Scripting Name Field |