PC_SCH_REC_DTL(SQL Table) |
Index Back |
|---|---|
PC Sched Record Field DetailDetail of record fields that will be used to build the templates used for integrating data with third party scheduling software. Each record field will be included in a class (record) in the dynamically generated xml file used in the data integration. |
| # | 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_LIST |
| 4 | PC_SCH_FIELDNAME |
Character(50) | VARCHAR2(50) NOT NULL |
Field Name
Prompt Table: PC_SCH_RCFLD_VW |
| 5 | ORDERBYNUM | Number(3,0) | SMALLINT NOT NULL | Order-By Number |
| 6 | PC_KEY | Character(1) | VARCHAR2(1) NOT NULL |
Key Indicator
N=No Y=Yes |
| 7 | PC_REQUIRED1 | Character(1) | VARCHAR2(1) NOT NULL |
Required Field Indicator
N=No Y=Yes |
| 8 | PC_FIELD_TYPE | Character(3) | VARCHAR2(3) NOT NULL |
Holds the type of field (i.e. string, numeric, etc.) for use in the Projects integration with scheduling tools.
NUM=Numeric Value STR=String Value |
| 9 | DEFFIELDNAME | Character(18) | VARCHAR2(18) NOT NULL | Default Field Name |