PYRE_PRELD_AET(SQL Table) |
Index Back |
|---|---|
Rapid Paysheets Pre-LoadState record for Ap Engine=PYRE_PRELD. This is used to load the PYRE_DETAIL records into PSHUP_TXN to prepare for the Load process. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PROCESS_INSTANCE | Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 2 | OPRID | Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
| 3 | RUN_CNTL_ID | Character(30) | VARCHAR2(30) NOT NULL | Run Control ID |
| 4 | RUN_ID | Character(10) | VARCHAR2(10) NOT NULL | Pay Run ID |
| 5 | PROCESS_ON_OFF | Character(1) | VARCHAR2(1) NOT NULL |
Process On or Off-Cycle
F=Off-Cycle Checks O=On-Cycle Checks |
| 6 | OFF_CYCLE | Character(1) | VARCHAR2(1) NOT NULL |
Off Cycle ?
Y/N Table Edit Default Value: Y |
| 7 | PU_SOURCE | Character(2) | VARCHAR2(2) NOT NULL |
Paysheet update source.
AM=Absence Management ER=Recruiting Interface EX=Expense Interface IM=SIM Interface OT=Other Sources PL=Lifetime Balance Payout USF RP=Rapid Paysheets SP=Stock Admin - ESPP Refunds ST=Stock Admin - Options & ESPP VC=Variable Compensation VF=Bonus from Fusion WI=What-If |
| 8 | PU_RESET | Character(1) | VARCHAR2(1) NOT NULL |
Process Option
P=Process Transactions R=Reset Transactions Default Value: P |
| 9 | EARNS_BEGIN_DT | Date(10) | DATE | Earnings Begin Date |
| 10 | EARNS_END_DT | Date(10) | DATE | Earnings End Date |
| 11 | EMPLID | Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 12 | EMPL_RCD | Number(3,0) | SMALLINT NOT NULL | Empl Record |
| 13 | SEQNO | Number(5,0) | INTEGER NOT NULL | Sequence Number |
| 14 | SEQ_NUM5 | Number(5,0) | INTEGER NOT NULL | Sequence Number |
| 15 | ERNCD | Character(3) | VARCHAR2(3) NOT NULL | Earnings Code |
| 16 | ERNCD2 | Character(3) | VARCHAR2(3) NOT NULL | Rapid Paysheets Earning Code |
| 17 | ERNCD3 | Character(3) | VARCHAR2(3) NOT NULL | Rapid Paysheets Earning Code |
| 18 | ERNCD4 | Character(3) | VARCHAR2(3) NOT NULL | Rapid Paysheets Earning Code |
| 19 | EARNS_AMT | Signed Number(12,2) | DECIMAL(10,2) NOT NULL | Earnings Amount |
| 20 | EARNS_AMT2 | Signed Number(12,2) | DECIMAL(10,2) NOT NULL | Pay period earnings amount. Used for public assistance data on Employment and Salary Verification integration file extract process. |
| 21 | EARNS_AMT3 | Signed Number(12,2) | DECIMAL(10,2) NOT NULL | Pay period earnings amount. Used for public assistance data on Employment and Salary Verification integration file extract process. |
| 22 | EARNS_HRS | Signed Number(8,2) | DECIMAL(6,2) NOT NULL | Earnings Hours |
| 23 | EARNS_HRS2 | Signed Number(8,2) | DECIMAL(6,2) NOT NULL | Pay period hours amount. Used for public assistance data on Employment and Salary Verification integration file extract process. |
| 24 | EARNS_HRS3 | Signed Number(8,2) | DECIMAL(6,2) NOT NULL | Pay period hours amount. Used for public assistance data on Employment and Salary Verification integration file extract process. |
| 25 | EARNS_HRS4 | Signed Number(8,2) | DECIMAL(6,2) NOT NULL | Pay period hours amount. Used for public assistance data on Employment and Salary Verification integration file extract process. |
| 26 | GROSSUP | Character(1) | VARCHAR2(1) NOT NULL | Gross-Up |
| 27 | SEPCHK | Number(2,0) | SMALLINT NOT NULL | Separate check number. |
| 28 | GB_GROUP_ID | Character(15) | VARCHAR2(15) NOT NULL | Group Build ID. |
| 29 | OPRID2 | Character(30) | VARCHAR2(30) NOT NULL | User ID |
| 30 | PYRE_TMPLT_ID | Character(15) | VARCHAR2(15) NOT NULL | Template ID for Rapid Entry Paysheets |
| 31 | PYRE_TMPLT_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Rapid Paysheets Template Type
A=Amount B=Hours or Amounts H=Hours |
| 32 | COUNTER | Signed Number(6,0) | DECIMAL(5) NOT NULL | Counter |
| 33 | TEXT_MSG | Character(100) | VARCHAR2(100) NOT NULL | Text Message |