FT_ASGN_NAME_VW (SQL View)	Index Back
Assignment Audit Name Assignment Audit Report Emplid Names

FT_ASGN_NAME_VW

(SQL View)

Assignment Audit Name

Assignment Audit Report Emplid Names

SELECT DISTINCT STG.FT_RUN_ID , STG.EMPLID , NAM.NAME FROM %Table(FT_ASSIGNMNT_IN) STG , %Table(NAMES) NAM WHERE STG.EMPLID = NAM.EMPLID AND %EffdtCheck(NAMES NAM2, NAM, FT_EFF_START_DATE) AND NAM.EFF_STATUS = 'A' AND NAM.NAME_TYPE = 'PRI'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 FT_RUN_ID Number(18,0) DECIMAL(18) NOT NULL LEGAL_ENTITY_ID

2 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

3 NAME Character(50) VARCHAR2(50) NOT NULL Name

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	FT_RUN_ID	Number(18,0)	DECIMAL(18) NOT NULL	LEGAL_ENTITY_ID
2	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
3	NAME	Character(50)	VARCHAR2(50) NOT NULL	Name