SJT_DEPT_TMP

(SQL Table)
Index Back

Job Opening Security Join Tbl

Job Opening Security Join Table - this table contains the denormalized security related attributes from Job Opening. This table is used to join to the HRMS Security framework.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
2 SCRTY_TYPE_CD Character(3) VARCHAR2(3) NOT NULL Security Type for RowLevelSecurty

Prompt Table: SCRTY_TYPE_TBL

3 SCRTY_KEY1 Character(20) VARCHAR2(20) NOT NULL Contains the value of the field used for row level security for Job access - setid.
4 SCRTY_KEY2 Character(20) VARCHAR2(20) NOT NULL Contains the value of the field used for Rowlevelsecurity access to JOB
5 SCRTY_KEY3 Character(20) VARCHAR2(20) NOT NULL Contains the value of the field used for Rowlevelsecurity access to JOB
6 SETID Character(5) VARCHAR2(5) NOT NULL SetID
7 DEPTID Character(10) VARCHAR2(10) NOT NULL Department
8 EFFDT_NOKEY Date(10) DATE Used in Records /Views where the EFFDT won't be a key
9 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