CP_GBL_VAR(SQL Table) |
Index Back |
---|---|
CP Global Variable TableCP Global Variable Table |
# | 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: OPR_DEF_TBL_FS.SETID Prompt Table: SP_SETID_NONVW |
2 | CP_VARIABLE | Character(18) | VARCHAR2(18) NOT NULL | Variable Field |
3 | CP_VARIABLE_DESCR | Character(30) | VARCHAR2(30) NOT NULL | Variable Description Field |
4 | CP_VALUE_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Value Type Field
C=Character N=Number |
5 | CP_VARIABLE_LEN | Number(2,0) | SMALLINT NOT NULL | Variable Length Field |
6 | CP_VARIABLE_DECI | Number(1,0) | SMALLINT NOT NULL | Variable Decimal Field |
7 | LASTUPDDTTM | DateTime(26) | TIMESTAMP | Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts. |