GPGB_SY15_RNCT2(SQL Table) |
Index Back |
|---|---|
NI update run control recNI update run control employee record for NI Contracted out change |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  OPRID |
Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
| 2 | RUN_CNTL_ID |
Character(30) | VARCHAR2(30) NOT NULL | Run Control ID |
| 3 | GPGB_NI_CON_OUT_FM |
Character(2) | VARCHAR2(2) NOT NULL |
GP UK Ni Contract out from
D=Standard C/Out Salary Related E=Reduced C/Out Salary Related I=C/Out Salary Related STD Rate K=Contracted-OMP-reduced Rate L=Deferment C/Out Salary Related N=Contracted-OSR-standard rate O=Contracted-OUS-reduced rate V=Mariners C/Out Salary Contri |
| 4 | GPGB_NI_CON_OUT_TO | Character(2) | VARCHAR2(2) NOT NULL |
GP UK NI Contracted out to
A=Standard Not C/Out B=Reduced Not C/Out J=Deferment Not C/Out M=Not contracted-out STD Rate R=Standard Rate T=Reduced Rate Y=Mariners not C/Out STD Rate Z=Not C/Out Deferred Rate |