ALIAS_NAMEAA=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_METHOD_USE(SQL View) |
Index Back |
|---|---|
table ids and custom stmts |
| select alias_name, alias_type, descr from PS_PA_ALIAS_USE where alias_type in ('CS', 'TL') |
| # | 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 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |