HP_FIELD_DESCRA=Active
I=Inactive
Default Value: A
A=All
D=Deductions
DT=Deductions and Taxes
E=Earnings
ED=Earnings and Deductions
ET=Earnings and Taxes
T=Tax
C=Character
N=Numeric
HP_DIST_FLDS(SQL Table) |
Index Back |
|---|---|
Distribution Field SelectionTable that contains a list of fields that can be used in the retro distribution process |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | HP_FIELD_DESCR |
Character(30) | VARCHAR2(30) NOT NULL | Field Description for use by Retro Distribution query |
| 2 | EFF_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Effective Status
A=Active I=Inactive Default Value: A |
| 3 | FIELDNAME | Character(18) | VARCHAR2(18) NOT NULL | Field Name (see PSDBFIELD). |
| 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_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Numeric or Character field.
C=Character N=Numeric |
| 6 | HP_FIELD_LENGTH | Number(3,0) | SMALLINT NOT NULL | Length og field, to be tested at field edti. |
| 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. |
| 8 | COUNTRY | Character(3) | VARCHAR2(3) NOT NULL | Country |
| 9 | UPDATE_FLAG | Character(1) | VARCHAR2(1) NOT NULL | Update Flag |
| 10 | HP_DIST_CHARTFLD | Character(1) | VARCHAR2(1) NOT NULL | Flag to indicate that the field used for distribution is a chartfield. |
| 11 | FIELDNAME1 | Character(18) | VARCHAR2(18) NOT NULL | Field Name 1 |