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
HP_FIELD_DESCRPrompt Table: %EDITTABLE
Y/N Table Edit
Default Value: N
RUN_HPSRCHDATA(SQL Table) |
Index Back |
|---|---|
Search Criteria Direct RetroSpecifying search criteria 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 | HP_FIELD_DESCR |
Character(30) | VARCHAR2(30) NOT NULL |
Field Description for use by Retro Distribution query
Prompt Table: %EDITTABLE |
| 6 | HP_FIELD_VALUE | Character(30) | VARCHAR2(30) NOT NULL | Field Value used for generic field search where the field name is not known |
| 7 | 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 |