HP_RPT_COLDEFN_CDHP_COLUMN_IDA=Column A
B=Column B
C=Column C
D=Column D
E=Column E
F=Column F
E=Gross
F=Fringe
Default Value: E
HP_COL_DEFN_COL(SQL Table) |
Index Back |
|---|---|
User Defined Report ColumnsGross and Fringe Report - setup table that stores the characteristic of each column. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | HP_RPT_COLDEFN_CD |
Character(5) | VARCHAR2(5) NOT NULL | This field identifies the report definition set that the report based on to cumulate gross wages and fringe benefits. |
| 2 | HP_COLUMN_ID |
Character(1) | VARCHAR2(1) NOT NULL |
This field identifies user-defined report column.
A=Column A B=Column B C=Column C D=Column D E=Column E F=Column F |
| 3 | HP_COL_HEADING1 | Character(13) | VARCHAR2(13) NOT NULL | This field stores the first column heading for each user defined report column. |
| 4 | HP_COL_HEADING2 | Character(13) | VARCHAR2(13) NOT NULL | This field stores the second column heading for each user defined report column. |
| 5 | HP_GROSS | Character(1) | VARCHAR2(1) NOT NULL |
This field identifies if the report column is for Gross wages or Fringe Benefits (taxes).
E=Gross F=Fringe Default Value: E |