PA_DT_AND_AL_V2 (SQL View)	Index Back
Date + DB Date Aliases

PA_DT_AND_AL_V2

(SQL View)

Date + DB Date Aliases

SELECT ALIAS_NAME ,DESCR FROM PS_PA_ALIAS_USE WHERE ALIAS_TYPE = 'DT' OR (ALIAS_TYPE = 'DB' and alias_fld_pic = 'DATE')

# 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

#	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