SETIDDefault Value: SHARE
Prompt Table: SP_SETID_NONVW
SCRIPT_IDDefault Value: 999999999999
RO_CAT_PADV_VW(SQL View) |
Index Back |
|---|
| SELECT SETID ,SCRIPT_ID ,SCRIPT_NAME FROM PS_RC_BSCRIPT A WHERE %EffdtCheck(RC_BSCRIPT B, A, %CurrentDateIn) AND A.SCRIPT_TYPE='PADV' AND EFF_STATUS = 'A' |
| # | 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 | SCRIPT_NAME | Character(40) | VARCHAR2(40) NOT NULL | Branch Scripting Name Field |