| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 PROCESS_INSTANCE |
Number(10,0) |
DECIMAL(10) NOT NULL |
Process Instance
|
| 2 |
RUN_CNTL_ID |
Character(30) |
VARCHAR2(30) NOT NULL |
Run Control ID
|
| 3 |
AE_TEST_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Test Flag
|
| 4 |
GB_GROUP_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Group Build ID.
|
| 5 |
GB_EFFDT |
Date(10) |
DATE |
Group As Of Date
|
| 6 |
PNLGRPNAME |
Character(18) |
VARCHAR2(18) NOT NULL |
Component Name
|
| 7 |
GB_QRYNAME |
Character(30) |
VARCHAR2(30) NOT NULL |
Query Name
|
| 8 |
GB_RECNAME_RESULT |
Character(18) |
VARCHAR2(18) NOT NULL |
Result Table
|
| 9 |
EDITTABLE |
Character(15) |
VARCHAR2(15) NOT NULL |
Edit Table
|
| 10 |
GB_VALUE |
Character(254) |
VARCHAR2(254) NOT NULL |
Field Value
|
| 11 |
GB_INSTANCE |
Number(10,0) |
DECIMAL(10) NOT NULL |
Process Instance
|
| 12 |
SELCOUNT |
Number(2,0) |
SMALLINT NOT NULL |
Select Count
|
| 13 |
SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
SetID
|
| 14 |
RCDCOUNT |
Number(2,0) |
SMALLINT NOT NULL |
Record Count
|
| 15 |
FLDCOUNT |
Number(3,0) |
SMALLINT NOT NULL |
Field Count
|
| 16 |
CRTCOUNT |
Number(3,0) |
SMALLINT NOT NULL |
Criteria Count
|
| 17 |
QRYDISTINCT |
Character(1) |
VARCHAR2(1) NOT NULL |
Distinct
|
| 18 |
QRYNAME |
Character(30) |
VARCHAR2(30) NOT NULL |
Query Name
|
| 19 |
HAVECRTCOUNT |
Number(3,0) |
SMALLINT NOT NULL |
Having Criteria Count
|
| 20 |
SELNUM |
Number(2,0) |
SMALLINT NOT NULL |
Select Number
|
| 21 |
RECNAME |
Character(15) |
VARCHAR2(15) NOT NULL |
Record (Table) Name (see PSRECDEFN).
|
| 22 |
FIELDNAME |
Character(18) |
VARCHAR2(18) NOT NULL |
Field Name (see PSDBFIELD).
|
| 23 |
COLUMNNUM |
Number(3,0) |
SMALLINT NOT NULL |
Column Number
|
| 24 |
COMBTYPE |
Number(1,0) |
SMALLINT NOT NULL |
Combination Type
|
| 25 |
CURRENCY_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Currency Code
|
| 26 |
NEGATION |
Character(1) |
VARCHAR2(1) NOT NULL |
Negation
|
| 27 |
LCRTFLDNUM |
Number(3,0) |
SMALLINT NOT NULL |
Left Criteria Field Number
|
| 28 |
CONDTYPE |
Number(2,0) |
SMALLINT NOT NULL |
Condition Type
|
| 29 |
EXPRTYPE |
Number(2,0) |
SMALLINT NOT NULL |
Expression Type
|
| 30 |
R1CRTEXPNUM |
Number(3,0) |
SMALLINT NOT NULL |
Right1 Criteria Expression No.
|
| 31 |
ACTION |
Character(3) |
VARCHAR2(3) NOT NULL |
Action
Prompt Table:
ACTION_TBL
|
| 32 |
SAL_ADMIN_PLAN |
Character(4) |
VARCHAR2(4) NOT NULL |
Salary Administration Plan
|
| 33 |
COMPANY |
Character(3) |
VARCHAR2(3) NOT NULL |
Company
|
| 34 |
PAYGROUP |
Character(3) |
VARCHAR2(3) NOT NULL |
Pay Group
|
| 35 |
GRADE |
Character(3) |
VARCHAR2(3) NOT NULL |
Salary Grade
|
| 36 |
TARIFF_GER |
Character(2) |
VARCHAR2(2) NOT NULL |
Tariff
01=Metal Processing
02=Banking
03=Building and Civil Engineering
04=Clothing Industry
05=Chemical Industry
06=Printing Industry
07=Retail Trade
08=Fossil Oil and Gas Extraction
09=Glass Industry
10=Wholesale and Foreign Trade
11=Wood Processing
12=Rubber Processing
13=Ceramics
14=Agriculture
15=Leather Processing
16=Public Sector
17=Paper Industry
18=Paper Processing
19=Sawing Industry
20=German Seaports
21=Hard-Coal Mining
22=Textile Industry
23=Insurance
24=Housing Industry
25=Periodical Publishers
26=Newspaper Publishers
27=Tobacco Industry
|
| 37 |
LABOR_AGREEMENT |
Character(6) |
VARCHAR2(6) NOT NULL |
Labor Agreement
Prompt Table:
EMPL_CTG
|
| 38 |
EMPL_CTG |
Character(6) |
VARCHAR2(6) NOT NULL |
Employee Category
Prompt Table:
EMPL_CTG_L1_VW
|
| 39 |
EMPL_CTG_L1 |
Character(6) |
VARCHAR2(6) NOT NULL |
Employee Subcategory
Prompt Table:
EMPL_CTG_L2_VW
|
| 40 |
GB_LANGUAGE_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Language Code
CFR=Canadian French
DUT=Dutch
ENG=English
ESP=Spanish
FRA=French
GER=German
INE=International English
JPN=Japanese
POR=Portuguese
|
| 41 |
R1CRTFLDNUM |
Number(3,0) |
SMALLINT NOT NULL |
Right1 Criteria Field Number
|
| 42 |
R2CRTEXPNUM |
Number(3,0) |
SMALLINT NOT NULL |
Right2 Criteria Expression No.
|
| 43 |
LPARENLVL |
Number(2,0) |
SMALLINT NOT NULL |
Left Paren Level
|
| 44 |
RPARENLVL |
Number(2,0) |
SMALLINT NOT NULL |
Right Paren Level
|
| 45 |
CRTNUM |
Number(3,0) |
SMALLINT NOT NULL |
Criteria Number
|
| 46 |
OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
A user's ID (see PSOPRDEFN).
|
| 47 |
BINDABLE_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Bindable?
|
| 48 |
ROW_COUNT |
Number(8,0) |
INTEGER NOT NULL |
Number to Purge
|
| 49 |
FIELDTYPE |
Number(2,0) |
SMALLINT NOT NULL |
Field Type (from PSST0101 Ref.)
|
| 50 |
LRECNAME |
Character(15) |
VARCHAR2(15) NOT NULL |
Left Record (Table) Name
|
| 51 |
LFIELDNAME |
Character(18) |
VARCHAR2(18) NOT NULL |
Left Field Name
|
| 52 |
RRECNAME |
Character(15) |
VARCHAR2(15) NOT NULL |
Right Record (Table) Name
|
| 53 |
RFIELDNAME |
Character(18) |
VARCHAR2(18) NOT NULL |
Right Field Name
|
| 54 |
XLATSHORTNAME |
Character(10) |
VARCHAR2(10) NOT NULL |
Translate Value Short Name
|
| 55 |
OPERAND_SEQ |
Number(3,0) |
SMALLINT NOT NULL |
Criteria Number
|
| 56 |
SQL_OPERATOR |
Character(1) |
VARCHAR2(1) NOT NULL |
SQL Operator
A=Equal
B=Less than
C=Greater than
D=Less or Equal
E=Greater or Equal
F=In List
G=Not in List
H=Between
I=Not Equal
J=Minimum
K=Maximum
L=Current
M=Is Null
N=Not Null
O=Not Between
P=Like
Q=Not Like
R=Effdt <=
S=Effdt >=
T=Effdt <
U=Effdt >
|
| 57 |
EFFDTOPERATOR_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Effective date operator flag
|
| 58 |
GROUP_RIGHT_PAREN |
Character(1) |
VARCHAR2(1) NOT NULL |
Right parentheses for group selection criteria.
0=
1=)
2=))
3=)))
4=))))
5=)))))
|
| 59 |
GROUP_LEFT_PAREN |
Character(1) |
VARCHAR2(1) NOT NULL |
Left Parentheses for groups.
0=
1=(
2=((
3=(((
4=((((
5=(((((
|
| 60 |
GROUP_BOOLEAN |
Character(3) |
VARCHAR2(3) NOT NULL |
Boolean for groups
AND=AND
OR=OR
|
| 61 |
GB_VALUE_NBR |
Number(3,0) |
SMALLINT NOT NULL |
Value Number
|
| 62 |
GB_VALUE_DT |
Date(10) |
DATE |
Date
|
| 63 |
GB_VALUE_DTTM |
DateTime(26) |
TIMESTAMP |
Date Time
|
| 64 |
GB_VALUE_TM |
Time(15) |
TIMESTAMP |
Time
|
| 65 |
ADD_FLD1_NAME |
Character(50) |
VARCHAR2(50) NOT NULL |
Additional Field 1 Name
|
| 66 |
ADD_FLD1_VALUE |
Character(50) |
VARCHAR2(50) NOT NULL |
Additional Field 1 Value
|
| 67 |
ADD_FLD2_NAME |
Character(50) |
VARCHAR2(50) NOT NULL |
Additional Field 2 Name
|
| 68 |
ADD_FLD2_VALUE |
Character(50) |
VARCHAR2(50) NOT NULL |
Additional Field 2 Value
|
| 69 |
ADD_FLD3_NAME |
Character(50) |
VARCHAR2(50) NOT NULL |
Additional Field 3 Name
|
| 70 |
ADD_FLD3_VALUE |
Character(50) |
VARCHAR2(50) NOT NULL |
Additional Field 3 Value
|
| 71 |
ADD_FLD4_NAME |
Character(50) |
VARCHAR2(50) NOT NULL |
Additional Field 4 Name
|
| 72 |
ADD_FLD4_VALUE |
Character(50) |
VARCHAR2(50) NOT NULL |
Additional Field 4 Value
|
| 73 |
LANGUAGE_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Language Code
|
| 74 |
LANG_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Language Code
CFR=Canadian French
DAN=Danish
DUT=Dutch
ENG=English
ESP=Spanish
FRA=French
GER=German
GRK=Greek
INE=International English
ITA=Italian
JPN=Japanese
KOR=Korean
POR=Portuguese
SVE=Swedish
THA=Thai
ZHS=Simplified Chinese
ZHT=Traditional Chinese
|
| 75 |
RELLANGRECNAME |
Character(15) |
VARCHAR2(15) NOT NULL |
Related Language Record Name
|
| 76 |
USEEDIT |
Number(10,0) |
DECIMAL(10) NOT NULL |
Field Use and Edit Flags- USEEDIT reference
|
| 77 |
VALUE_SEQ |
Number(3,0) |
SMALLINT NOT NULL |
Sequence
|
| 78 |
PRCSINSTANCE |
Number(10,0) |
DECIMAL(10) NOT NULL |
Process Instance
|
| 79 |
VERSIONQRYDDFN |
Number(10,0) |
DECIMAL(10) NOT NULL |
Developer Query Version
|
| 80 |
VERSIONQRYUDFN |
Number(10,0) |
DECIMAL(10) NOT NULL |
User Query Version
|
| 81 |
VERSIONGBQDM |
Number(10,0) |
DECIMAL(10) NOT NULL |
Version Number
|
| 82 |
VERSION |
Number(10,0) |
DECIMAL(10) NOT NULL |
Version. Internal PeopleTools version for controlling caching of object. - Version/Table reference
|
| 83 |
GB_OLD_VERSION |
Number(10,0) |
DECIMAL(10) NOT NULL |
Old Version
|
| 84 |
GB_OLD_RES_TBL |
Character(18) |
VARCHAR2(18) NOT NULL |
Result Table
|
| 85 |
ASOFDATE |
Date(10) |
DATE |
As of Date
|
| 86 |
PROCESS_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Process Status
A=Active
C=Successfully Completed
E=Completed With Errors
N=Not Yet Processed
P=Processing Now
|
| 87 |
COUNTER |
Signed Number(6,0) |
DECIMAL(5) NOT NULL |
Counter
|
| 88 |
JOBINSTANCE |
Number(10,0) |
DECIMAL(10) NOT NULL |
Job Instance
|
| 89 |
DESCR254 |
Character(254) |
VARCHAR2(254) NOT NULL |
Description of length 254
|
| 90 |
ACTION_ITA |
Character(3) |
VARCHAR2(3) NOT NULL |
Turnover - Action
HIR=Hire
LAY=Lay off
LEA=Leave of Absence
TER=Termination
|
| 91 |
EXPRESSIONTEXT |
Long Character |
CLOB |
Expression Text
|
| 92 |
COMPLEX_GROUP_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Complex Group - Batch Process
Default Value: N
|
| 93 |
COUNTRY |
Character(3) |
VARCHAR2(3) NOT NULL |
Country
|
| 94 |
TASKGROUP |
Character(10) |
VARCHAR2(10) NOT NULL |
Taskgroup
|
| 95 |
GVT_HIGH_PAY_PLAN |
Character(2) |
VARCHAR2(2) NOT NULL |
Highest Pay Plan
|
| 96 |
GVT_NOA_CODE |
Character(3) |
VARCHAR2(3) NOT NULL |
Nature of Action Code
|
| 97 |
GVT_RTND_GRADE |
Character(3) |
VARCHAR2(3) NOT NULL |
Retained Grade
|
| 98 |
GVT_RTND_PAY_PLAN |
Character(2) |
VARCHAR2(2) NOT NULL |
Retained Pay Plan
|
| 99 |
GVT_RTND_SAL_PLAN |
Character(4) |
VARCHAR2(4) NOT NULL |
Retained Pay Table
|
| 100 |
INTCP_COMPANY2 |
Character(3) |
VARCHAR2(3) NOT NULL |
Company Appointment (JAPAN HR)
|
| 101 |
AE_ROW_COUNT |
Number(4,0) |
SMALLINT NOT NULL |
in Scroll
|
| 102 |
GB_SEQ_NBR |
Number(3,0) |
SMALLINT NOT NULL |
Group Build - Sequence Number
|
| 103 |
COUNTRY_NM_FORMAT |
Character(3) |
VARCHAR2(3) NOT NULL |
Supported Name Format Types
Prompt Table:
NAME_FORMAT_TBL
|