| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
A user's ID (see PSOPRDEFN).
Default Value: OPR_DEF_TBL_FS.OPRID
Prompt Table:
OPR_DEF_TBL_FS
|
| 2 |
RUN_CNTL_ID |
Character(30) |
VARCHAR2(30) NOT NULL |
Run Control ID
|
| 3 |
SYSTEM_SOURCE |
Character(3) |
VARCHAR2(3) NOT NULL |
Identifies the application or source system that generated a journal entry.
Release 8.80 - 11/14/2002 - RVlasic - Removed GDM (JrnlGen - Deduction Management) from Translate Values.
SUJ---Included a label as Product.
Release 8.9 - 05/11/2005 - RVlasic - Added PRV (Variance Pricing) and PKK (KK Budget Journal) and deleted GLK for Project Costing per Brian Cohen.
Default Value: RS
Prompt Table:
RS_SYS_SRCVW
|
| 4 |
SRCH_TYPE_CD |
Character(5) |
VARCHAR2(5) NOT NULL |
Search Type
Prompt Table:
RS_SRCH_TYP_VW
|
| 5 |
INDEX_CACHE_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Index Administration
Y/N Table Edit
Default Value: N
|
| 6 |
REFRESH_WO_ORG_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Resource Organizational Unit
Y/N Table Edit
Default Value: N
|
| 7 |
WRKR_DATE_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Resource Date Cache
Y/N Table Edit
Default Value: N
|
| 8 |
CREATE_UPDATE |
Character(1) |
VARCHAR2(1) NOT NULL |
Create or Update
C=Create New
I=Insert
P=Purge
U=Update Existing
Default Value: U
|
| 9 |
LANG_OPTION |
Character(1) |
VARCHAR2(1) NOT NULL |
Language Option
A=All Installed Languages
S=Base Language
Default Value: A
|
| 10 |
LANGUAGE_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Language Code
|
| 11 |
RS_INDEX |
Character(1) |
VARCHAR2(1) NOT NULL |
Index
A=Assignment
R=Resource
Default Value: R
|
| 12 |
SRCH_INDEX_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
Indexing Option
C=Create New
O=Optimize
U=Update Existing
|
| 13 |
EMPL_CACHE_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Maintain Employee Data Cache
Y/N Table Edit
Default Value: N
|
| 14 |
SCP_CACHE_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Refresh Supply/Demand Cache
Y/N Table Edit
Default Value: N
|
| 15 |
OCP_CACHE_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Refresh cache for supply category analytics
Y/N Table Edit
|
| 16 |
CREATE_UPD_EMP_CAC |
Character(1) |
VARCHAR2(1) NOT NULL |
Create or Update
C=Create New
U=Update Existing
Default Value: U
|
| 17 |
CURR_ELGBL_WO_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Eligible Resource Cache
Y/N Table Edit
Default Value: N
|
| 18 |
FACTOR_CLEANUP_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Factor Cleanup
Y/N Table Edit
Default Value: N
|
| 19 |
MATCH_CACHE_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Refresh Match Cache
N=No
Y=Yes
Default Value: N
|
| 20 |
UPD_CMPL_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Update Assignment Completion
Y/N Table Edit
Default Value: N
|
| 21 |
RS_SEARCH_ENGINE |
Character(1) |
VARCHAR2(1) NOT NULL |
Search Engine
S=Search
V=Unused
|
| 22 |
RS_UPD_SYNC |
Character(1) |
VARCHAR2(1) NOT NULL |
Update resources calendar synchronously with assignment update.
Default Value: N
|