| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 ALIAS_NAME |
Character(10) |
VARCHAR2(10) NOT NULL |
Alias Name
|
| 2 |
ALIAS_TYPE |
Character(2) |
VARCHAR2(2) NOT NULL |
Alias type
AA=Auto Assigned (Lim/Unlim Vals)
CS=Custom Statement
DB=Data Base Field
DT=Date Field
DU=Duration (Age) Field
FR=Function Result
TL=Table Lookup
Default Value: DB
|
| 3 |
ALIAS_TBL_NAME |
Character(18) |
VARCHAR2(18) NOT NULL |
Alias Table Name
|
| 4 |
ALIAS_FLD_NAME |
Character(18) |
VARCHAR2(18) NOT NULL |
Alias Field Name
|
| 5 |
ALIAS_FLD_PIC |
Character(10) |
VARCHAR2(10) NOT NULL |
Alias Field Picture
|
| 6 |
EG_WHERE_CLS_TYPE |
Character(2) |
VARCHAR2(2) NOT NULL |
Education & Government -specific field. Used in Tenure Tracking system and in Flexible Service Date Tracking.
ED=Employee ID & Effective Date
EE=Employee ID Keyed
PE=Employee ID & Service Calc Grp
|
| 7 |
DURR_XREF_ALIAS |
Character(10) |
VARCHAR2(10) NOT NULL |
Duration x-ref alias name
|
| 8 |
AUTO_ASSOC_PLAN_NM |
Character(6) |
VARCHAR2(6) NOT NULL |
Auto assignment assoc plan
|
| 9 |
AUTO_ASSOC_FR_NM |
Character(10) |
VARCHAR2(10) NOT NULL |
Auto asgnmt assoc func rslt nm
|
| 10 |
AUTO_CONCEPT_CD |
Character(2) |
VARCHAR2(2) NOT NULL |
Auto assignment concept
LA=Limited Average Earnings
LB=Limited Cash Balance @ BCD
LL=Lim Cash Bal @ Lump Sum Date
LN=Limited Cash Balance @ NRD
PD=Participation Date
UA=Unlimited Average Earnings
UB=Unlimited Cash Balance @ BCD
UL=Unlim Cash Bal @ Lump Sum Date
UN=Unlimited Cash Balance @ NRD
|
| 11 |
TBL_STRT_EFF_CD |
Character(1) |
VARCHAR2(1) NOT NULL |
Start/Effdt use indicator
|
| 12 |
EG_SEQ_NUM |
Number(3,0) |
SMALLINT NOT NULL |
Sequence Number
|
| 13 |
DESCR |
Character(30) |
VARCHAR2(30) NOT NULL |
Description
|
| 14 |
ALIAS_PROMPT |
Character(40) |
VARCHAR2(40) NOT NULL |
Alias Prompt Field
Default Value: EG_ALIAS_USE.ALIAS_NAME
|
| 15 |
DESCR50 |
Character(50) |
VARCHAR2(50) NOT NULL |
Description of length 50
|
| 16 |
PSTABLE |
Character(1) |
VARCHAR2(1) NOT NULL |
People Soft Table
Y/N Table Edit
Default Value: Y
|