SJT_DEPT_TMP(SQL Table) |
Index Back |
---|---|
Job Opening Security Join TblJob 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 |