ALIAS_NAMEALIAS_TYPEAA=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
PA_KEYFIELDPA_KEYVALUEPA_USERECPA_USEFIELDPA_ALIAS_XREF(SQL Table) |
Index Back |
|---|---|
AliasesThis is a setup table containing Aliases. |
| # | 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 |
| 3 | PA_KEYFIELD |
Character(18) | VARCHAR2(18) NOT NULL | Key Field Name |
| 4 | PA_KEYVALUE |
Character(18) | VARCHAR2(18) NOT NULL | Key Field Value |
| 5 | PA_USEREC |
Character(15) | VARCHAR2(15) NOT NULL | Used by Record |
| 6 | PA_USEFIELD |
Character(18) | VARCHAR2(18) NOT NULL | Used by Field |