RA_PROF_REG_VW

(SQL View)
 Index Back

Custom Profile table


SELECT RA_PROFILE_ID , RA_PROFILE_NAME , RA_PROFILE_TYPE , RA_PROFILE_GROUP , DESCR254 , RA_PROFILE_STATUS , RA_ONE_OR_MANY , RA_PROFILE_RECNAME , ROW_ADDED_DTTM , ROW_ADDED_OPRID , ROW_LASTMANT_DTTM , ROW_LASTMANT_OPRID , SYNCID , SYNCDTTM FROM PS_RA_PROFILE WHERE RA_PROFILE_STATUS IN ('REQ', 'ACT')

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 RA_PROFILE_ID Number(18,0) DECIMAL(18) NOT NULL Profile - profile ID
2 RA_PROFILE_NAME Character(80) VARCHAR2(80) NOT NULL Profile - Name
3 RA_PROFILE_TYPE Character(4) VARCHAR2(4) NOT NULL Profile - Type
SYS=System Global
USER=User
4 RA_PROFILE_GROUP Character(3) VARCHAR2(3) NOT NULL Profile - Group
IND=Individuals
ORG=Organizations

Default Value: IND

5 DESCR254 Character(254) VARCHAR2(254) NOT NULL Description of length 254
6 RA_PROFILE_STATUS Character(3) VARCHAR2(3) NOT NULL Profile - status
AC1=Activating
ACT=Activated
DES=In Design
INA=Inactivated
REJ=Rejected
REQ=Requested
UPD=Update

Default Value: DES

7 RA_ONE_OR_MANY Character(1) VARCHAR2(1) NOT NULL Profile - One or Many
M=Many rows
N=One row

Default Value: N

8 RA_PROFILE_RECNAME Character(15) VARCHAR2(15) NOT NULL Profile - record name
9 ROW_ADDED_DTTM DateTime(26) TIMESTAMP This is a datetime field for record creation.
10 ROW_ADDED_OPRID Character(30) VARCHAR2(30) NOT NULL ID of user who added the row.
11 ROW_LASTMANT_DTTM DateTime(26) TIMESTAMP The date and time that the row was last updated.
12 ROW_LASTMANT_OPRID Character(30) VARCHAR2(30) NOT NULL ID of user who last modified the row.
13 SYNCID Number(10,0) DECIMAL(10) NOT NULL The Synchronization ID field stores a value generated by the sync processor. The value is used to identify the type of object that the sync processor is about to handle.
14 SYNCDTTM DateTime(26) TIMESTAMP Synchronization Last Update Date Time