PC_SCH_RECNAMEPC_SCH_FIELDNAMEPC_SCH_RCFLD_VW(SQL View) |
Index Back |
|---|---|
View of PeopleSoft record fldsPeopleSoft record fields mapped to the record field used in the Projects third party scheduling product integration. |
| SELECT recname ,fieldname FROM PSRECFIELD a WHERE a.fieldnum = ( SELECT MIN(b.fieldnum) FROM PSRECFIELD b WHERE a.recname = b.recname AND a.fieldname = b.fieldname) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PC_SCH_RECNAME |
Character(30) | VARCHAR2(30) NOT NULL | Record (Table) Name |
| 2 | PC_SCH_FIELDNAME |
Character(50) | VARCHAR2(50) NOT NULL | Field Name |