Record Type Values

April 7, 2010 — Stephen aka DigitalEagle
This page has moved.  Please update your links:
http://psst0101.digitaleagle.net/2010/04/07/record-type-values/

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.

Posted in Fields, PeopleTools, Records. 3 Comments »

3 Responses to “Record Type Values”

  1. Praj Says:
    April 12, 2010 at 3:02 am

    I’m curious as to whatever happen to record type 4 – any ideas?

    Reply
  2. digitaleagle Says:
    April 12, 2010 at 7:30 am

    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.

    Reply
  3. Sreekanth Reddy Says:
    August 9, 2010 at 8:38 am

    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.

    Reply

Leave a comment

«

»