BUSINESS_UNITFED_PROGRAMEFFDTDefault Value: %date
PRIORITY_ORDERFIELDNAMEPrompt Table: CF_ACTIVE_VW
RANGE_FROMPrompt Table:
%EDITTABLE
Set Control Field: BUSINESS_UNIT
RANGE_TOPrompt Table:
%EDITTABLE
Set Control Field: BUSINESS_UNIT
FOMB_PRGAC_MAPR(SQL Table) |
Index Back |
|---|---|
FOMB Program Activity MappingFOMB Program Activity Mapping |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 2 | FED_PROGRAM |
Character(4) | VARCHAR2(4) NOT NULL | Fed Program Code |
| 3 | EFFDT |
Date(10) | DATE |
Effective Date
Default Value: %date |
| 4 | PRIORITY_ORDER |
Number(5,0) | INTEGER NOT NULL | Priority Order for Schedules |
| 5 | FIELDNAME |
Character(18) | VARCHAR2(18) NOT NULL |
Field Name (see PSDBFIELD).
Prompt Table: CF_ACTIVE_VW |
| 6 | RANGE_FROM |
Character(30) | VARCHAR2(30) NOT NULL |
Lower boundary for detail value that contains a range of values
Prompt Table:
%EDITTABLE
|
| 7 | RANGE_TO |
Character(30) | VARCHAR2(30) NOT NULL |
Upper boundary for detail value that contains a range of values
Prompt Table:
%EDITTABLE
|