CP_VAR_INQ_VW(SQL View) |
Index Back |
|---|---|
Variable Search Result WorkThis record is used by Variable Search Result page (CP_VAR_IN2) |
| SELECT 'T' , CP_TEMPLATE_ID , ' ' , SETID , CP_TEMPLATE_ID , ' ' FROM PS_CP_TEMP_DETL |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | CP_VAR_CD_TYPE | Character(2) | VARCHAR2(2) NOT NULL |
Variable Code Type Field
01=Constraint 02=Internal Variable 03=Matrix 04=Multiple Option 05=Rule 06=Template 07=Expression 08=Message 09=Value List |
| 2 | CP_VALUE | Character(18) | VARCHAR2(18) NOT NULL | Variable Value Field |
| 3 | CP_VAR_DETAIL | Character(254) | VARCHAR2(254) NOT NULL | Variable Detail Field |
| 4 | CP_KEY1 | Character(20) | VARCHAR2(20) NOT NULL | Character Key 1 Field |
| 5 | CP_KEY2 | Character(18) | VARCHAR2(18) NOT NULL | Character Key 2 Field |
| 6 | CP_KEY3 | Character(10) | VARCHAR2(10) NOT NULL | Character Key 3 Field |