FPY_LOC_STG_TBL

(SQL Table)
 Index Back

Staging Table for Location

Staging Table created for Fusion Payroll Integration for Location.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 FPY_SETID Character(50) VARCHAR2(50) NOT NULL Setid
2 FPY_LOCATION_ID Number(18,0) DECIMAL(18) NOT NULL Location Id
3 FPY_EFF_END_DT Character(50) VARCHAR2(50) NOT NULL Effective End Date
4 FPY_START_DTTM Character(50) VARCHAR2(50) NOT NULL Start Date Time
5 EFFDT Date(10) DATE Effective Date

Default Value: %date

6 SETID Character(5) VARCHAR2(5) NOT NULL SetID

Prompt Table: SET_VLD_HR_03

7 LOCATION Character(10) VARCHAR2(10) NOT NULL Location Code
8 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
9 FPY_PROC_MARKER Character(36) VARCHAR2(36) NOT NULL FPY_PROC_MARKER
10 FPY_ERROR_FLAG Character(1) VARCHAR2(1) NOT NULL FPY Error Flag
N=No
Y=Yes
11 FPY_MODE Character(1) VARCHAR2(1) NOT NULL FPY_MODE
12 FPY_JOB_CI Character(1) VARCHAR2(1) NOT NULL FPY_JOB_CI
13 FPY_PROCESSED_FLG Character(1) VARCHAR2(1) NOT NULL Processed Flag
14 FPY_BYPASS_FLG Character(1) VARCHAR2(1) NOT NULL Bypass Flag
15 FPY_ERR_CORR_REQD Character(1) VARCHAR2(1) NOT NULL Correction Required
N=No
Y=Yes
16 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
17 FPY_FLOOR_NUMBER Character(160) VARCHAR2(160) NOT NULL Floor Number
18 FPY_REG_REGION Long Character(480) VARCHAR2(480) Reg Region
19 FPY_LOCATION_CD Character(128) VARCHAR2(128) NOT NULL Location Code
20 FPY_EXTENSION Character(120) VARCHAR2(120) NOT NULL Phone Extension
21 FPY_POSTAL Character(120) VARCHAR2(120) NOT NULL Postal
22 FPY_STATE Long Character(480) VARCHAR2(480) State
23 FPY_STATE1 Long Character(480) VARCHAR2(480) Canada States
24 FPY_COUNTY Character(120) VARCHAR2(120) NOT NULL County
25 FPY_PHONE Character(240) VARCHAR2(240) NOT NULL Phone
26 FPY_CITY Character(120) VARCHAR2(120) NOT NULL City
27 FPY_EFF_STATUS Character(120) VARCHAR2(120) NOT NULL Active Status
28 FPY_FAX Character(120) VARCHAR2(120) NOT NULL Fax Number
29 FPY_ADDRESS1 Long Character(960) VARCHAR2(960) Address1
30 FPY_ADDRESS2 Long Character(960) VARCHAR2(960) Address2
31 FPY_ADDRESS3 Long Character(960) VARCHAR2(960) Address3
32 FPY_COUNTRY Character(240) VARCHAR2(240) NOT NULL Country
33 FPY_DESCR_AC Character(120) VARCHAR2(120) NOT NULL Description
34 FPY_BUILDING Character(18) VARCHAR2(18) NOT NULL Building
35 FPY_ADDRESS4 Long Character(960) VARCHAR2(960) Address4
36 FPY_DESCR Long Character CLOB Description
37 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
A=Active
I=Inactive

Default Value: A

38 DESCR254A Character(254) VARCHAR2(254) NOT NULL Long Description
39 DESCR Character(30) VARCHAR2(30) NOT NULL Description
40 DESCR_AC Character(30) VARCHAR2(30) NOT NULL Alternate Char Description
41 FLOOR Character(10) VARCHAR2(10) NOT NULL Floor Nbr
42 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country
43 REG_REGION Character(5) VARCHAR2(5) NOT NULL Regulatory Region

Prompt Table: REG_REGION_TBL

44 BUILDING Character(10) VARCHAR2(10) NOT NULL Building Nbr
45 ADDRESS1 Character(55) VARCHAR2(55) NOT NULL Address 1
46 ADDRESS2 Character(55) VARCHAR2(55) NOT NULL Address 2
47 ADDRESS3 Character(55) VARCHAR2(55) NOT NULL Address 3
48 ADDRESS4 Character(55) VARCHAR2(55) NOT NULL Address 4
49 CITY Character(30) VARCHAR2(30) NOT NULL City
50 ESTABID Character(12) VARCHAR2(12) NOT NULL Establishment ID
51 HOLIDAY_SCHEDULE Character(6) VARCHAR2(6) NOT NULL Holiday Schedule
52 COUNTY Character(30) VARCHAR2(30) NOT NULL County
53 STATE Character(6) VARCHAR2(6) NOT NULL State
54 POSTAL Character(12) VARCHAR2(12) NOT NULL Postal
55 COUNTRY_CODE Character(3) VARCHAR2(3) NOT NULL Country Code
56 PHONE Character(24) VARCHAR2(24) NOT NULL Telephone
57 EXTENSION Character(6) VARCHAR2(6) NOT NULL Phone number extension
58 FAX Character(24) VARCHAR2(24) NOT NULL Fax Number