OPRIDRUN_CNTL_IDFROM_DATEHP_BUDGET_DATATYPEA=All
D=Deductions
DT=Deductions and Taxes
E=Earnings
ED=Earnings and Deductions
ET=Earnings and Taxes
T=Tax
SEQNUMRUN_HPUPDTSEQ(SQL Table) |
Index Back |
|---|---|
Update Sequence ProcessingUpdate Sequence Processing for Direct Retro Distribution |
| # | 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 | FROM_DATE |
Date(10) | DATE NOT NULL | From Date |
| 4 | HP_BUDGET_DATATYPE |
Character(2) | VARCHAR2(2) NOT NULL |
Budget Data Type for specifying if Earnings, Deductions, or Taxes
A=All D=Deductions DT=Deductions and Taxes E=Earnings ED=Earnings and Deductions ET=Earnings and Taxes T=Tax |
| 5 | SEQNUM |
Number(3,0) | SMALLINT NOT NULL | Sequence Number |
| 6 | AMOUNT | Signed Number(20,3) | DECIMAL(18,3) NOT NULL | Commuting Allowance Paid Per Cycle. |