FPY_PERSON_ADDR

(SQL Table)
 Index Back

Person Address Staging Table

Person Address Staging Table

# 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_ADDRESS_ID Character(30) VARCHAR2(30) NOT NULL Address
4 FPY_PRI_ADDR_TYPE Character(120) VARCHAR2(120) NOT NULL Address Type
5 FPY_START_DTTM Character(50) VARCHAR2(50) NOT NULL Start Date Time
6 FPY_EFF_END_DT Character(50) VARCHAR2(50) NOT NULL Effective End Date
7 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
8 FPY_PROC_MARKER Character(36) VARCHAR2(36) NOT NULL FPY_PROC_MARKER
9 FPY_ERROR_FLAG Character(1) VARCHAR2(1) NOT NULL FPY Error Flag
N=No
Y=Yes
10 FPY_MODE Character(1) VARCHAR2(1) NOT NULL FPY_MODE
11 FPY_JOB_CI Character(1) VARCHAR2(1) NOT NULL FPY_JOB_CI
12 FPY_PROCESSED_FLG Character(1) VARCHAR2(1) NOT NULL Processed Flag
13 FPY_BYPASS_FLG Character(1) VARCHAR2(1) NOT NULL Bypass Flag
14 FPY_ERR_CORR_REQD Character(1) VARCHAR2(1) NOT NULL Correction Required
N=No
Y=Yes
15 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
16 FPY_ADDRESS1 Long Character(960) VARCHAR2(960) Address1
17 FPY_ADDRESS2 Long Character(960) VARCHAR2(960) Address2
18 FPY_ADDRESS3 Long Character(960) VARCHAR2(960) Address3
19 FPY_ADDRESS4 Long Character(960) VARCHAR2(960) Address4
20 ADDRESS_TYPE Character(4) VARCHAR2(4) NOT NULL Address Type

Prompt Table: ADDRESS_TYP_TBL

21 ADDRESS1 Character(55) VARCHAR2(55) NOT NULL Address 1
22 ADDRESS2 Character(55) VARCHAR2(55) NOT NULL Address 2
23 ADDRESS3 Character(55) VARCHAR2(55) NOT NULL Address 3
24 ADDRESS4 Character(55) VARCHAR2(55) NOT NULL Address 4
25 FPY_CITY Character(120) VARCHAR2(120) NOT NULL City
26 FPY_COUNTRY Character(240) VARCHAR2(240) NOT NULL Country
27 FPY_COUNTY Character(120) VARCHAR2(120) NOT NULL County
28 FPY_STATE Long Character(480) VARCHAR2(480) State
29 FPY_POSTAL Character(120) VARCHAR2(120) NOT NULL Postal
30 FPY_REG_REGION Long Character(480) VARCHAR2(480) Reg Region
31 CITY Character(30) VARCHAR2(30) NOT NULL City
32 POSTAL Character(12) VARCHAR2(12) NOT NULL Postal
33 COUNTY Character(30) VARCHAR2(30) NOT NULL County
34 STATE Character(6) VARCHAR2(6) NOT NULL State
35 GEO_CODE Character(11) VARCHAR2(11) NOT NULL Geo Code
36 REG_REGION Character(5) VARCHAR2(5) NOT NULL Regulatory Region
37 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country

Prompt Table: COUNTRY_TBL

38 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
39 EFFDT Date(10) DATE Effective Date

Default Value: %date