Types of Record in PeopleSoft
Types of Record in PeopleSoft. The values for the RECTYPE field in the PSRECDEFN that stores the information about the records in PeopleSoft.
- 0 = SQL Table
- 1 = SQL View
- 2 = Work Record
- 3 = Subrecord
- 5 = Dynamic View
- 6 = Query View
- 7 = Temp Table
For example sql, you can do something like this to find all the tables that have the OPRID field:
|
1 2 3 4 5 |
SELECT A.RECNAME FROM PSRECDEFN A, PSRECFIELDALL B WHERE A.RECNAME = B.RECNAME AND A.RECTYPE = 0 AND B.FIELDNAME = 'OPRID' |
Reference: https://psst0101.wordpress.com/2010/04/07/record-type-values/