FPY_PERSON_TBL

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	FPY_PERSON_ID	Character(18)	VARCHAR2(18) NOT NULL	Person ID
2	FPY_PERSON_NUM	Character(120)	VARCHAR2(120) NOT NULL	Person Number
3	FPY_START_DTTM	Character(50)	VARCHAR2(50) NOT NULL	Start Date Time
4	FPY_EFF_END_DT	Character(50)	VARCHAR2(50) NOT NULL	Effective End Date
5	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
6	FPY_PROC_MARKER	Character(36)	VARCHAR2(36) NOT NULL	FPY_PROC_MARKER
7	FPY_ERROR_FLAG	Character(1)	VARCHAR2(1) NOT NULL	FPY Error Flag N=No Y=Yes
8	FPY_MODE	Character(1)	VARCHAR2(1) NOT NULL	FPY_MODE
9	FPY_JOB_CI	Character(1)	VARCHAR2(1) NOT NULL	FPY_JOB_CI
10	FPY_PROCESSED_FLG	Character(1)	VARCHAR2(1) NOT NULL	Processed Flag
11	FPY_BYPASS_FLG	Character(1)	VARCHAR2(1) NOT NULL	Bypass Flag
12	FPY_ERR_CORR_REQD	Character(1)	VARCHAR2(1) NOT NULL	Correction Required N=No Y=Yes
13	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
14	FPY_PRI_ADDR_TYPE	Character(120)	VARCHAR2(120) NOT NULL	Address Type
15	FPY_BIRTHDATE	Character(50)	VARCHAR2(50) NOT NULL	Birth Date
16	FPY_PRI_EMAIL_ID	Character(100)	VARCHAR2(100) NOT NULL	Primary Email ID
17	FPY_LEGALENTITY_ID	Number(18,0)	DECIMAL(18) NOT NULL	Field to hold the value of Company coming from Fusion.
18	FPY_PRI_NID_ID	Character(100)	VARCHAR2(100) NOT NULL	NID ID
19	FPY_PRI_NID_NUM	Character(100)	VARCHAR2(100) NOT NULL	NID Number
20	FPY_PRI_PHONE_ID	Character(100)	VARCHAR2(100) NOT NULL	Phone ID
21	FPY_PER_ORG	Character(120)	VARCHAR2(120) NOT NULL	Per Org
22	EFFDT	Date(10)	DATE	Effective Date Default Value: %date
23	PER_ORG	Character(3)	VARCHAR2(3) NOT NULL	Defines the Organizational Relationship(s) that a Person has to the Organization. These are Employee, Contingent Worker, and Persons of Interest. CWR=Contingent Worker EMP=Employee POI=Person of Interest
24	POI_TYPE	Character(5)	VARCHAR2(5) NOT NULL	Defines the Transactional usage of POIs in HRMS.
25	BIRTHDATE	Date(10)	DATE	Date of Birth
26	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID