PA_TBL_PG_ALS

(SQL View)
 Index Back

Table Names w/type 'I' View


select a.alias_name ,a.descr from PS_PA_TBL_LOOKUP a ,ps_pa_alias_use b where a.alias_name = b.alias_name and a.tl_lkup1_type_cd = 'I'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 ALIAS_NAME Character(10) VARCHAR2(10) NOT NULL Alias Name
2 DESCR Character(30) VARCHAR2(30) NOT NULL Description