PSHUP_RP_TAO(SQL Table) |
Index Back |
|---|---|
Temp rcd - Ap Eng =PYRE_VALIDThis record is used as temporary for PSHUP Inactive Employees during Rapid Paysheet Validation. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  PROCESS_INSTANCE |
Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 2 | PYRE_TMPLT_TYPE |
Character(1) | VARCHAR2(1) NOT NULL |
Rapid Paysheets Template Type
A=Amount B=Hours or Amounts H=Hours |
| 3 | PYRE_TMPLT_ID |
Character(15) | VARCHAR2(15) NOT NULL | Template ID for Rapid Entry Paysheets |
| 4 | RUN_ID |
Character(10) | VARCHAR2(10) NOT NULL | Pay Run ID |
| 5 | OFF_CYCLE |
Character(1) | VARCHAR2(1) NOT NULL | Off Cycle ? |
| 6 | OPRID |
Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
| 7 | EARNS_BEGIN_DT |
Date(10) | DATE | Earnings Begin Date |
| 8 | EARNS_END_DT |
Date(10) | DATE | Earnings End Date |
| 9 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 10 | EMPL_RCD |
Number(3,0) | SMALLINT NOT NULL | Empl Record |
| 11 | SEQNO |
Number(5,0) | INTEGER NOT NULL | Sequence Number |
| 12 | COMPANY | Character(3) | VARCHAR2(3) NOT NULL | Company |
| 13 | PAYGROUP | Character(3) | VARCHAR2(3) NOT NULL | Pay Group |
| 14 | PAY_END_DT | Date(10) | DATE | Pay Period End Date |
| 15 | EMPL_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Payroll Status
A=Active D=Deceased L=Leave of Absence P=Leave With Pay Q=Retired With Pay R=Retired S=Suspended T=Terminated U=Terminated With Pay V=Terminated Pension Pay Out W=Short Work Break X=Retired-Pension Administration |