SJT_PERSON (SQL Table)	Index Back
Security dat for Person Access This Table is used for Security. It contains the access to Person's either by the JOB data or by the POI data. This table is updated via an App Engine process which is triggered by subscriptions on WORKFORCE_SYNC and PERSON_BASIC_SYNC. It is also updated every night to catch future dated changes as they become active. This table is also updated with peoplecode on saves of PERS_NID, PER_POI_TYPE, PER_POI_SCRTY, and JOB.

SJT_PERSON

(SQL Table)

Security dat for Person Access

This Table is used for Security. It contains the access to Person's either by the JOB data or by the POI data. This table is updated via an App Engine process which is triggered by subscriptions on WORKFORCE_SYNC and PERSON_BASIC_SYNC. It is also updated every night to catch future dated changes as they become active. This table is also updated with peoplecode on saves of PERS_NID, PER_POI_TYPE, PER_POI_SCRTY, and JOB.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 SCRTY_TYPE_CD Character(3) VARCHAR2(3) NOT NULL Security Type for RowLevelSecurty
Prompt Table: SCRTY_TYPE_TBL

2 SCRTY_KEY1 Character(20) VARCHAR2(20) NOT NULL Contains the value of the field used for row level security for Job access - setid.

3 SCRTY_KEY2 Character(20) VARCHAR2(20) NOT NULL Contains the value of the field used for Rowlevelsecurity access to JOB

4 SCRTY_KEY3 Character(20) VARCHAR2(20) NOT NULL Contains the value of the field used for Rowlevelsecurity access to JOB

5 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
Prompt Table: PERSON_NAME

6 POI_TYPE Character(5) VARCHAR2(5) NOT NULL Defines the Transactional usage of POIs in HRMS.
Prompt Table: POI_TYPE_TBL

7 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

8 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Rcd Nbr

9 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

10 SETID_DEPT Character(5) VARCHAR2(5) NOT NULL Department SetID

11 DEPTID Character(10) VARCHAR2(10) NOT NULL Department

12 SETID_LOCATION Character(5) VARCHAR2(5) NOT NULL Location SetID

13 LOCATION Character(10) VARCHAR2(10) NOT NULL Location Code

14 COMPANY Character(3) VARCHAR2(3) NOT NULL Company

15 REG_REGION Character(5) VARCHAR2(5) NOT NULL Regulatory Region

16 APPT_TYPE Character(1) VARCHAR2(1) NOT NULL This field tracks whether a row is a Main Appointment (which all rows outside Japan are), or an Additional Appointment, which is a feature only used by Japanese customers.
0=Core Appointment
1=Japan Kenmu Appointment
2=French Public Sector Appt
3=Staffing

17 HR_STATUS Character(1) VARCHAR2(1) NOT NULL HR Status
A=Active
I=Inactive

18 EMPL_STATUS Character(1) VARCHAR2(1) NOT NULL Payroll Status
A=Active
D=Deceased
L=Leave of Absence
P=Leave With Pay
Q=Retired With Pay
R=Retired
S=Suspended
T=Terminated
U=Terminated With Pay
V=Terminated Pension Pay Out
W=Short Work Break
X=Retired-Pension Administration

19 OTHER_ID_JPN Character(11) VARCHAR2(11) NOT NULL Other Identifier

20 REPORTS_TO Character(8) VARCHAR2(8) NOT NULL Reports To Position Number

21 SUPERVISOR_ID Character(11) VARCHAR2(11) NOT NULL Supervisor ID

22 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution

23 NATIONAL_ID Character(20) VARCHAR2(20) NOT NULL National ID

24 SETID_JOBCODE Character(5) VARCHAR2(5) NOT NULL Job Code SetID

25 JOBCODE Character(6) VARCHAR2(6) NOT NULL Job Code

26 MAIN_APPT_NUM_JPN Number(3,0) SMALLINT NOT NULL Tracks the empl_rcd for the Main Appointment of this row. For a Main Appointment, this field stores the same value as the current empl_rcd, for an Additional Appointment, it stores the value of a different empl_rcd.

27 ORG_INSTANCE_ERN Number(3,0) SMALLINT NOT NULL Indicates which EMPL_RCD (ERN) is considered the Organizational Instance for this particular ERN. An Organizational Instance defines an Instance of Employment or an Instance of Contingent Workforce. Hire, Termination, and Service dates are captured at the Organiational Instance level.

28 HOME_HOST_CLASS Character(1) VARCHAR2(1) NOT NULL Home/Host Classification
M=Home
S=Host

29 PAY_SYSTEM_FLG Character(2) VARCHAR2(2) NOT NULL Payroll System
GP=Global Payroll
NA=Payroll for North America
OT=Other
PI=Payroll Interface

30 GP_PAYGROUP Character(10) VARCHAR2(10) NOT NULL Global Payroll pay group

31 PAYGROUP Character(3) VARCHAR2(3) NOT NULL Pay Group

32 MILITARY_SERVICE Character(8) VARCHAR2(8) NOT NULL Military Service

33 MIL_RANK Character(5) VARCHAR2(5) NOT NULL Military Rank

34 MIL_WORN_RANK Character(5) VARCHAR2(5) NOT NULL Worn Rank

35 EFFDT_NOKEY Date(10) DATE Used in Records /Views where the EFFDT won't be a key

36 EFFSEQ_NOKEY Number(3,0) SMALLINT NOT NULL Field used in views where EFFSEQ won't be a key

37 HCR_HOME_HOST_TYPE Character(1) VARCHAR2(1) NOT NULL Field to indicate whether International Security will be used. This field has the values of 'None', 'Both','Home can see Host','Host can see Home'.
1=Home can see Host
2=Host can see Home
3=Both

38 HCR_JPN_SEC_FLG Character(1) VARCHAR2(1) NOT NULL Use the Additional Appointment (Kenmu) Security? Only allowed if INSTALLATION.JPN = 'Y' and INSTALLATION.AA_ENABLED_JPN = 'Y'.
Y/N Table Edit

39 HCR_ASGN_TYPE Character(1) VARCHAR2(1) NOT NULL Access Type
1=Instance can see Assignment
2=Assignment can see Instance
3=Both
4=None

40 FUTURE_FLG Character(1) VARCHAR2(1) NOT NULL Flag for the SJT_*** record that indicates whether this is a future dated row or not. Y = Future N = Current
Y/N Table Edit
Default Value: N

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SCRTY_TYPE_CD	Character(3)	VARCHAR2(3) NOT NULL	Security Type for RowLevelSecurty Prompt Table: SCRTY_TYPE_TBL
2	SCRTY_KEY1	Character(20)	VARCHAR2(20) NOT NULL	Contains the value of the field used for row level security for Job access - setid.
3	SCRTY_KEY2	Character(20)	VARCHAR2(20) NOT NULL	Contains the value of the field used for Rowlevelsecurity access to JOB
4	SCRTY_KEY3	Character(20)	VARCHAR2(20) NOT NULL	Contains the value of the field used for Rowlevelsecurity access to JOB
5	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID Prompt Table: PERSON_NAME
6	POI_TYPE	Character(5)	VARCHAR2(5) NOT NULL	Defines the Transactional usage of POIs in HRMS. Prompt Table: POI_TYPE_TBL
7	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
8	EMPL_RCD	Number(3,0)	SMALLINT NOT NULL	Empl Rcd Nbr
9	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
10	SETID_DEPT	Character(5)	VARCHAR2(5) NOT NULL	Department SetID
11	DEPTID	Character(10)	VARCHAR2(10) NOT NULL	Department
12	SETID_LOCATION	Character(5)	VARCHAR2(5) NOT NULL	Location SetID
13	LOCATION	Character(10)	VARCHAR2(10) NOT NULL	Location Code
14	COMPANY	Character(3)	VARCHAR2(3) NOT NULL	Company
15	REG_REGION	Character(5)	VARCHAR2(5) NOT NULL	Regulatory Region
16	APPT_TYPE	Character(1)	VARCHAR2(1) NOT NULL	This field tracks whether a row is a Main Appointment (which all rows outside Japan are), or an Additional Appointment, which is a feature only used by Japanese customers. 0=Core Appointment 1=Japan Kenmu Appointment 2=French Public Sector Appt 3=Staffing
17	HR_STATUS	Character(1)	VARCHAR2(1) NOT NULL	HR Status A=Active I=Inactive
18	EMPL_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Payroll Status A=Active D=Deceased L=Leave of Absence P=Leave With Pay Q=Retired With Pay R=Retired S=Suspended T=Terminated U=Terminated With Pay V=Terminated Pension Pay Out W=Short Work Break X=Retired-Pension Administration
19	OTHER_ID_JPN	Character(11)	VARCHAR2(11) NOT NULL	Other Identifier
20	REPORTS_TO	Character(8)	VARCHAR2(8) NOT NULL	Reports To Position Number
21	SUPERVISOR_ID	Character(11)	VARCHAR2(11) NOT NULL	Supervisor ID
22	INSTITUTION	Character(5)	VARCHAR2(5) NOT NULL	Academic Institution
23	NATIONAL_ID	Character(20)	VARCHAR2(20) NOT NULL	National ID
24	SETID_JOBCODE	Character(5)	VARCHAR2(5) NOT NULL	Job Code SetID
25	JOBCODE	Character(6)	VARCHAR2(6) NOT NULL	Job Code
26	MAIN_APPT_NUM_JPN	Number(3,0)	SMALLINT NOT NULL	Tracks the empl_rcd for the Main Appointment of this row. For a Main Appointment, this field stores the same value as the current empl_rcd, for an Additional Appointment, it stores the value of a different empl_rcd.
27	ORG_INSTANCE_ERN	Number(3,0)	SMALLINT NOT NULL	Indicates which EMPL_RCD (ERN) is considered the Organizational Instance for this particular ERN. An Organizational Instance defines an Instance of Employment or an Instance of Contingent Workforce. Hire, Termination, and Service dates are captured at the Organiational Instance level.
28	HOME_HOST_CLASS	Character(1)	VARCHAR2(1) NOT NULL	Home/Host Classification M=Home S=Host
29	PAY_SYSTEM_FLG	Character(2)	VARCHAR2(2) NOT NULL	Payroll System GP=Global Payroll NA=Payroll for North America OT=Other PI=Payroll Interface
30	GP_PAYGROUP	Character(10)	VARCHAR2(10) NOT NULL	Global Payroll pay group
31	PAYGROUP	Character(3)	VARCHAR2(3) NOT NULL	Pay Group
32	MILITARY_SERVICE	Character(8)	VARCHAR2(8) NOT NULL	Military Service
33	MIL_RANK	Character(5)	VARCHAR2(5) NOT NULL	Military Rank
34	MIL_WORN_RANK	Character(5)	VARCHAR2(5) NOT NULL	Worn Rank
35	EFFDT_NOKEY	Date(10)	DATE	Used in Records /Views where the EFFDT won't be a key
36	EFFSEQ_NOKEY	Number(3,0)	SMALLINT NOT NULL	Field used in views where EFFSEQ won't be a key
37	HCR_HOME_HOST_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Field to indicate whether International Security will be used. This field has the values of 'None', 'Both','Home can see Host','Host can see Home'. 1=Home can see Host 2=Host can see Home 3=Both
38	HCR_JPN_SEC_FLG	Character(1)	VARCHAR2(1) NOT NULL	Use the Additional Appointment (Kenmu) Security? Only allowed if INSTALLATION.JPN = 'Y' and INSTALLATION.AA_ENABLED_JPN = 'Y'. Y/N Table Edit
39	HCR_ASGN_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Access Type 1=Instance can see Assignment 2=Assignment can see Instance 3=Both 4=None
40	FUTURE_FLG	Character(1)	VARCHAR2(1) NOT NULL	Flag for the SJT_*** record that indicates whether this is a future dated row or not. Y = Future N = Current Y/N Table Edit Default Value: N