FPY_PERSON_VW

(SQL View)

SELECT 'Person' ,EMPLID FROM PS_FPY_PERSON_TBL WHERE FPY_PROCESSED_FLG='Y' UNION ALL SELECT 'Person Address' , EMPLID FROM PS_FPY_PERSON_ADDR WHERE FPY_PROCESSED_FLG='Y' UNION ALL SELECT 'Person Email' , EMPLID FROM PS_FPY_PERS_EMAIL WHERE FPY_PROCESSED_FLG='Y' UNION ALL SELECT 'Person NID' , EMPLID FROM PS_FPY_PERS_NID WHERE FPY_PROCESSED_FLG='Y' UNION ALL SELECT 'Person Phone' , EMPLID FROM PS_FPY_PERS_PHONE WHERE FPY_PROCESSED_FLG='Y'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 FPY_BUS_OBJ Character(3) VARCHAR2(3) NOT NULL Business Object
ABS=Absence
ADD=Person Address
ALL=All
BNS=Bonus
BUS=Business Unit
CCI=Company
CMP=Compensation Data
COM=Company
DCI=Department
DEP=Department
EML=Person Email
JCD=JobCode
JCI=Job Data
JOB=Job Data
LCI=Location
LEG=Person Legislative Data
LOC=Location
NAM=Person Name
NID=Person National Identifier
OCI=JobCode
ORG=Organisation Instance
PCI=Person
PER=Person
PHN=Person Phone
POS=Position
SCI=Position

2 FPY_EMPLID Character(30) VARCHAR2(30) NOT NULL Employee ID

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	FPY_BUS_OBJ	Character(3)	VARCHAR2(3) NOT NULL	Business Object ABS=Absence ADD=Person Address ALL=All BNS=Bonus BUS=Business Unit CCI=Company CMP=Compensation Data COM=Company DCI=Department DEP=Department EML=Person Email JCD=JobCode JCI=Job Data JOB=Job Data LCI=Location LEG=Person Legislative Data LOC=Location NAM=Person Name NID=Person National Identifier OCI=JobCode ORG=Organisation Instance PCI=Person PER=Person PHN=Person Phone POS=Position SCI=Position
2	FPY_EMPLID	Character(30)	VARCHAR2(30) NOT NULL	Employee ID