HP_FUNDSRC_INFO(SQL Table) |
Index Back |
|---|---|
Funding Source InformationThis table stores the funding end date for each funding source defined on Valid Combo table. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | Character(25) | VARCHAR2(25) NOT NULL |
The code represents a combination of GL and PC chartfields
Prompt Table: HP_VAL_COMBO_VW |
|
| 2 | FDM_HASH | Character(31) | VARCHAR2(31) NOT NULL | Hash function |
| 3 | FUNDING_END_DT | Date(10) | DATE NOT NULL | Funding End Date |
| 4 | HR_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
HR Status
A=Active I=Inactive Default Value: A |