Here are the values for the RECTYPE field in the table that stores the information about the records in PeopleSoft: PSRECDEFN. Here are what the values mean:
- 0 = SQL Table
- 1 = SQL View
- 2 = Work Record
- 3 = Subrecord
- 5 = Dynamic View
- 6 = Query View
- 7 = Temp Table
For example, you can do something like this to find all the tables that have the OPRID field:
SELECT A.RECNAME FROM PSRECDEFN A, PSRECFIELDALL B WHERE A.RECNAME = B.RECNAME AND A.RECTYPE = 0 AND B.FIELDNAME = 'OPRID'
See the PeopleTools Tables for more information.
3 thoughts on “Record Type Values”
I’m curious as to whatever happen to record type 4 – any ideas?
I am not sure. There must have been some other type of record that no longer exists. I would guess that I just don’t have one of the types on my system, but I believe all the ones from the Record Type tab in PeopleSoft were accounted for. So, I don’t know.
Hi,no worries, it covers all 7 record types
Only thing it starts from 0.So that should be 0-6 or else 1-7.I’m sure that there is no other record type exists.