PSHUPLD_RUNCTL(SQL Table) |
Index Back |
|---|---|
Paysheet Load Report Run CntrlThis record is used as the Run Control for the Paysheet Load Report. This Load process is used to create paysheets using data from other products, for example stock and expenses. |
| # | 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 | 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 |
| 4 | PU_TXN_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Paysheet transaction status.
A=Active E=Exclude I=Inactive I=Loaded M=Manually Paid R=Rejected X=In Progress Prompt Table: %EDITTABLE |
| 5 | ACTVE_INACTVE_SEL | Character(1) | VARCHAR2(1) NOT NULL |
Active Inactive Selection field
A=Active I=Inactive |