SETIDDefault Value: OPR_DEF_TBL_FS.SETID
Prompt Table: SP_SETID_NONVW
CP_VARIABLEC=Character
N=Number
CP_OPT_VAR_VW(SQL View) |
Index Back |
|---|---|
CP Option Variables ViewCP Option Variables |
| SELECT DISTINCT SETID , CP_VARIABLE , CP_VALUE_TYPE , CP_VARIABLE_LEN , CP_VARIABLE_DECI , CP_VARIABLE_DESCR FROM PS_CP_OPT_VAR |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SETID |
Character(5) | VARCHAR2(5) NOT NULL |
SetID
Default Value: OPR_DEF_TBL_FS.SETID Prompt Table: SP_SETID_NONVW |
| 2 | CP_VARIABLE |
Character(18) | VARCHAR2(18) NOT NULL | Variable Field |
| 3 | CP_VALUE_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Value Type Field
C=Character N=Number |
| 4 | CP_VARIABLE_LEN | Number(2,0) | SMALLINT NOT NULL | Variable Length Field |
| 5 | CP_VARIABLE_DECI | Number(1,0) | SMALLINT NOT NULL | Variable Decimal Field |
| 6 | CP_VARIABLE_DESCR | Character(30) | VARCHAR2(30) NOT NULL | Variable Description Field |