PC_SCH_REC_MAPS(SQL Table) |
Index Back |
|---|---|
PC Sched Field MapsField mappings showing the relationship between a field in a third party scheduling product and a field in PeopleSoft Projects. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  PC_SCH_PRODUCT |
Character(3) | VARCHAR2(3) NOT NULL |
Product code used by Projects to determine the third party scheduling product being integrated with.
Prompt Table: PC_SCH_PRODUCT |
| 2 | PC_SCH_PROD_VAL |
Character(4) | VARCHAR2(4) NOT NULL |
Scheduling Product
3P=Third Party Scheduling Product PS=PeopleSoft Projects SIGN=Signon |
| 3 | PC_SCH_RECNAME |
Character(30) | VARCHAR2(30) NOT NULL |
Record (Table) Name
Prompt Table: PC_SCH_REC_VW |
| 4 | PC_SCH_FIELDNAME |
Character(50) | VARCHAR2(50) NOT NULL |
Field Name
Prompt Table: PC_SCH_REC_DTL |
| 5 | PC_MAP_PROD_VAL | Character(4) | VARCHAR2(4) NOT NULL |
Scheduling Products
3P=Third Party Scheduling Product PS=PeopleSoft Projects SIGN=Signon |
| 6 | PC_MAP_RECORD | Character(30) | VARCHAR2(30) NOT NULL |
Mapped Record for the Scheduling Integration
Prompt Table: PC_SCH_REC2_VW |
| 7 | PC_MAP_FIELDS | Character(50) | VARCHAR2(50) NOT NULL |
Mapped Fields for Scheduling Integration
Prompt Table: PC_SCH_RECFL_VW |