RETROPAYPGM_TBL(SQL Table) |
Index Back |
|---|---|
Retro Pay Program TableRetro Pay Program Table |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  RETROPAY_PGM_ID |
Character(3) | VARCHAR2(3) NOT NULL | Retro Pay Program ID |
| 2 | EFFDT |
Date(10) | DATE NOT NULL |
Effective Date
Default Value: %date |
| 3 | EFF_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Effective Status
A=Active I=Inactive Default Value: A |
| 4 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 5 | DESCRSHORT | Character(10) | VARCHAR2(10) NOT NULL | Short Description |
| 6 | OFF_CYCLE | Character(1) | VARCHAR2(1) NOT NULL |
Off Cycle ?
Y/N Table Edit Default Value: N |
| 7 | EXCEPTION_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
Exception - Chg in Pay Period
Y/N Table Edit Default Value: N |
| 8 | TIME_AND_LABOR | Character(1) | VARCHAR2(1) NOT NULL |
Time &&Labor - Chg in Pay Perd
Y/N Table Edit Default Value: N |
| 9 | SEPCHK_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
Separate check flag.
Y/N Table Edit Default Value: N |
| 10 | NEGPAY_OFSET_ERNCD | Character(3) | VARCHAR2(3) NOT NULL |
Offset Earn. Type for -ve Pay
Prompt Table: EARNINGS_TBL |
| 11 | TAX_METHOD | Character(1) | VARCHAR2(1) NOT NULL |
Tax method.
A=Annualized B=Bonus C=Cumulative G=Aggregate L=Lump Sum M=Commission P=Specified on Paysheet S=Supplemental X=Special Supplemental Default Value: S |
| 12 | TAX_PERIODS | Number(2,0) | SMALLINT NOT NULL |
Tax Periods
Default Value: 1 |