SJT_PERSON_USF(SQL Table) |
Index Back |
|---|---|
Security dat for Person AccessThis 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 | EMPL_RCD | Number(3,0) | SMALLINT NOT NULL | Empl Record |
| 7 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 8 | SETID_DEPT | Character(5) | VARCHAR2(5) NOT NULL | Department Set ID |
| 9 | DEPTID | Character(10) | VARCHAR2(10) NOT NULL | Department |
| 10 | SETID_LOCATION | Character(5) | VARCHAR2(5) NOT NULL | Location Set ID |
| 11 | LOCATION | Character(10) | VARCHAR2(10) NOT NULL | Location Code |
| 12 | COMPANY | Character(3) | VARCHAR2(3) NOT NULL | Company |
| 13 | REG_REGION | Character(5) | VARCHAR2(5) NOT NULL | Regulatory Region |
| 14 | 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 |
| 15 | REPORTS_TO | Character(8) | VARCHAR2(8) NOT NULL | Reports To Position Number |
| 16 | SUPERVISOR_ID | Character(11) | VARCHAR2(11) NOT NULL | Supervisor ID |
| 17 | NATIONAL_ID | Character(20) | VARCHAR2(20) NOT NULL | National ID |
| 18 | SETID_JOBCODE | Character(5) | VARCHAR2(5) NOT NULL | Job Code Set ID |
| 19 | JOBCODE | Character(6) | VARCHAR2(6) NOT NULL | Job Code |
| 20 | GVT_WIP_STATUS | Character(3) | VARCHAR2(3) NOT NULL |
Work-in-Progress Status
Prompt Table: GVT_WIP_STS_VW |
| 21 | GVT_STATUS_TYPE | Character(3) | VARCHAR2(3) NOT NULL |
Status Type
CAN=Cancelled COM=Completed COR=Corrected IRR=IRR Reported WIP=Work-in-progress |
| 22 | GVT_NOA_CODE | Character(3) | VARCHAR2(3) NOT NULL |
Nature of Action Code
Prompt Table: GVT_NOAC_TBL |
| 23 | GVT_RETIRE_PLAN | Character(2) | VARCHAR2(2) NOT NULL | Retirement Plan |
| 24 | 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 |