| # |
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 |
COMPANY |
Character(3) |
VARCHAR2(3) NOT NULL |
Company
Prompt Table:
COMPANY_TBL
|
| 4 |
ESTABID |
Character(12) |
VARCHAR2(12) NOT NULL |
Establishment ID
Prompt Table:
ESTAB_TBL
|
| 5 |
GPMX_CAPPED |
Character(1) |
VARCHAR2(1) NOT NULL |
Ceiling - GP Mexico
Y/N Table Edit
Default Value: N
|
| 6 |
GPMX_FREQ_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Period Type
B=Bimonthly
C=Calendar Group
M=Monthly
Y=Yearly
Default Value: B
|
| 7 |
GPMX_MONTH_FROM |
Character(2) |
VARCHAR2(2) NOT NULL |
Month From
01=January
02=February
03=March
04=April
05=May
06=June
07=July
08=August
09=September
10=October
11=November
12=December
|
| 8 |
GPMX_MONTH_THRU |
Character(2) |
VARCHAR2(2) NOT NULL |
Month Thru
01=January
02=February
03=March
04=April
05=May
06=June
07=July
08=August
09=September
10=October
11=November
12=December
|
| 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
|
| 10 |
GPMX_BALANCE_YEAR |
Number(4,0) |
SMALLINT NOT NULL |
Balance Year GP Mexico
|
| 11 |
CAL_RUN_ID |
Character(18) |
VARCHAR2(18) NOT NULL |
Calendar Run Id
Prompt Table:
GP_CAL_RUN
|
| 12 |
GPMX_PIN_DAYS_NUM |
Number(8,0) |
INTEGER NOT NULL |
Paid Days
Prompt Table:
GP_PIN_AC0_VW
|