SJT_PERSON_VW (SQL View)	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_VW

(SQL View)

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.

SELECT SCRTY_TYPE_CD ,SCRTY_KEY1 ,SCRTY_KEY2 ,SCRTY_KEY3 ,EMPLID ,POI_TYPE ,EMPL_RCD ,MAIN_APPT_NUM_JPN ,ORG_INSTANCE_ERN ,HOME_HOST_CLASS ,HCR_HOME_HOST_TYPE ,HCR_JPN_SEC_FLG ,HCR_ASGN_TYPE ,FUTURE_FLG FROM PS_SJT_PERSON

# 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 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Rcd Nbr

8 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.

9 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.

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

11 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

12 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

13 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

14 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	EMPL_RCD	Number(3,0)	SMALLINT NOT NULL	Empl Rcd Nbr
8	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.
9	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.
10	HOME_HOST_CLASS	Character(1)	VARCHAR2(1) NOT NULL	Home/Host Classification M=Home S=Host
11	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
12	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
13	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
14	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