PV_HR8_DEFAULTS(SQL Table) |
Index Back |
|---|---|
Requester Integration Defaults8/30/07 - JK - Added Record Description. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SYMBOLICID | Character(8) | VARCHAR2(8) NOT NULL |
The foreign key linking the PSOPRDEFN table to PSACCESSPRFL
Prompt Table: %EDITTABLE |
| 2 | LANGUAGE_CD | Character(3) | VARCHAR2(3) NOT NULL | Language Code |
| 3 | MULTILANG | Number(1,0) | SMALLINT NOT NULL | Used to determine if user is Multi-Lingual |
| 4 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL |
Currency Code
Prompt Table: CURRENCY_CD_TBL |
| 5 | PRCSPRFLCLS | Character(30) | VARCHAR2(30) NOT NULL |
A class that determines a user's process profile
Prompt Table: PSCLASSDEFN |
| 6 | DEFAULTNAVHP | Character(30) | VARCHAR2(30) NOT NULL |
Default Navigator Home Page
Prompt Table: PSCLASSDEFN |
| 7 | SETID_JOBCODE | Character(5) | VARCHAR2(5) NOT NULL |
Job Code SetID
Prompt Table: SP_SETID_NONVW |
| 8 | JOBCODE | Character(6) | VARCHAR2(6) NOT NULL |
Job Code
Prompt Table: JOBCODE_TBL |
| 9 | PASSWORD | Character(254) | VARCHAR2(254) NOT NULL | Password |
| 10 | PSWDEXPIRED | Character(1) | VARCHAR2(1) NOT NULL |
Expire Password at next Login
Y/N Table Edit Default Value: N |
| 11 | DEFAULT_SETID | Character(5) | VARCHAR2(5) NOT NULL |
Default SetID
Prompt Table: SP_SETID_NONVW |
| 12 | DEFAULT_BU | Character(5) | VARCHAR2(5) NOT NULL |
Default Business Unit
Prompt Table: SP_BUS_FS_NONVW |
| 13 | ROLENAME | Character(30) | VARCHAR2(30) NOT NULL |
The name of a Role in the Role Definition Table (see PSROLEDEFN).
Prompt Table: PSROLEDEFN |
| 14 | ROLENAME2 | Character(30) | VARCHAR2(30) NOT NULL |
The name of a Role in the Role Definition Table
Prompt Table: PSROLEDEFN |
| 15 | ROLENAME3 | Character(30) | VARCHAR2(30) NOT NULL |
The name of a Role in the Role Definition Table
Prompt Table: PSROLEDEFN |
| 16 | ROLENAME4 | Character(30) | VARCHAR2(30) NOT NULL |
The name of a Role in the Role Definition Table
Prompt Table: PSROLEDEFN |
| 17 | OPRCLASS | Character(30) | VARCHAR2(30) NOT NULL |
Operator Class
Prompt Table: PSCLASSDEFN |
| 18 | ROWSECCLASS | Character(30) | VARCHAR2(30) NOT NULL |
The class used to determine row level security
Prompt Table: PSCLASSDEFN |
| 19 | SHIPTO_ID | Character(10) | VARCHAR2(10) NOT NULL |
Ship To Location
Prompt Table: SHIP_SHIPSET_VW |
| 20 | LOCATION | Character(10) | VARCHAR2(10) NOT NULL |
Location Code
Prompt Table: LOC_LOCSET_VW |
| 21 | ORIGIN | Character(3) | VARCHAR2(3) NOT NULL |
Origin
Prompt Table: ORGN_ORGNSET_VW |