GPMX_NRP_CAP_VW(SQL View) |
Index Back |
|---|---|
Base Over Cap Run ControlBase Over Cap Run Control Element Relationship |
| SELECT OPRID , RUN_CNTL_ID , COMPANY , ESTABID , GPMX_CAPPED , GPMX_FREQ_TYPE , GPMX_MONTH_FROM , GPMX_MONTH_THRU , GPMX_BIMONTH_CD , GPMX_BALANCE_YEAR , CAL_RUN_ID , GPMX_PIN_DAYS_NUM + 50000000 FROM PS_GPMX_RC_CAP_BSE |
| # | 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 |
| 4 | ESTABID | Character(12) | VARCHAR2(12) NOT NULL | Establishment ID |
| 5 | GPMX_CAPPED | Character(1) | VARCHAR2(1) NOT NULL | Ceiling - GP Mexico |
| 6 | GPMX_FREQ_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Period Type
B=Bimonthly C=Calendar Group M=Monthly Y=Yearly |
| 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 |
| 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 |
| 12 | GPMX_PIN_DAYS_NUM | Number(8,0) | INTEGER NOT NULL | Paid Days |