POS_ALAS_AMT_VW (SQL View)	Index Back
Returns the Amount Alias Names Return the PS_SOURCE_ID and ALIAS_NAME's for all the amount fields

POS_ALAS_AMT_VW

(SQL View)

Returns the Amount Alias Names

Return the PS_SOURCE_ID and ALIAS_NAME's for all the amount fields

select POS_SOURCE_ID, ALIAS_NAME from PS_POS_SOURCE_TBL2 where ALIAS_NAME = (Select ALIAS_NAME from PS_POS_FIELD_TYPE where POS_FIELD_TYPE = '03' )

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 POS_SOURCE_ID Character(18) VARCHAR2(18) NOT NULL "A unique key identifier that represents a position source dataset

2 ALIAS_NAME Character(30) VARCHAR2(30) NOT NULL "A user defined synonym

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	POS_SOURCE_ID	Character(18)	VARCHAR2(18) NOT NULL	"A unique key identifier that represents a position source dataset
2	ALIAS_NAME	Character(30)	VARCHAR2(30) NOT NULL	"A user defined synonym