GPMX_RC_SDI(SQL Table) |
Index Back |
|---|---|
SDI ProcessSDI Process by Anniversary and SMG |
| # | 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 | GP_PAYGROUP | Character(10) | VARCHAR2(10) NOT NULL |
Global Payroll pay group
Prompt Table:
GP_PYGRP
|
| 4 | GPMX_SDI_TYPE | Character(4) | VARCHAR2(4) NOT NULL |
SDI Type by Anniversary or SMG Change
0010=SDI by Anniversary 0020=SDI by UMA Change 0030=SDI Mass Calculation 0040=SDI Triggers Default Value: 0010 |
| 5 | BGN_DT | Date(10) | DATE | Begin Date |
| 6 | END_DT | Date(10) | DATE | end date |
| 7 | GPMX_DELETE_DATA | Character(1) | VARCHAR2(1) NOT NULL |
Delete Data
Y/N Table Edit Default Value: N |
| 8 | GPMX_BALANCE_YEAR | Number(4,0) | SMALLINT NOT NULL | Balance Year GP Mexico |
| 9 | GPMX_BIMONTH_CD | Character(2) | VARCHAR2(2) NOT NULL |
Bimonth Code
01=1st Bimonth 02=2nd Bimonth 03=3rd Bimonth 04=4th Bimonth 05=5th Bimonth 06=6th Bimonth Default Value: 01 |