PA_METHOD_USE_C

(SQL View)
Index Back

CUSTOM STATEMENT VIEW


select alias_name, alias_type, descr from PS_PA_ALIAS_USE where alias_type = 'CS'

# 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