DATE_FIELDPRJ_DATE_FLD_VW(SQL View) |
Index Back |
|---|---|
View of Date Flds in Proj_Res |
| SELECT A.FIELDNAME FROM PSRECFIELD A, PSDBFIELD B WHERE A.RECNAME = 'PROJ_RESOURCE' AND A.FIELDNAME = B.FIELDNAME AND B.FIELDTYPE = 4 |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | DATE_FIELD |
Character(18) | VARCHAR2(18) NOT NULL | Date Field |