RUN_HPUPDTDATA(SQL Table) |
Index Back |
|---|---|
Retro Dist Field UpdatesDirect Retro Distribution Field Replacement Values |
| # | 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 | HP_FIELD_DESC |
Character(30) | VARCHAR2(30) NOT NULL |
Field Description for use by Retro Distribution query
Prompt Table: %EDITTABLE2 |
| 7 | HP_FIELD_VALUE | Character(30) | VARCHAR2(30) NOT NULL |
Field Value used for generic field search where the field name is not known
Prompt Table: %EDITTABLE3 |
| 8 | HP_USE_SPACES | Character(1) | VARCHAR2(1) NOT NULL |
Allowed to search and uodate with spaces. IE Field on database actually can contain space, not required.
Y/N Table Edit Default Value: N |