RA_PROF_ACT_VW (SQL View)	Index Back
Custom Profile table Custom Profile table containing information on profiles

RA_PROF_ACT_VW

(SQL View)

Custom Profile table

Custom Profile table containing information on profiles

SELECT RA_PROFILE_ID , RA_PROFILE_NAME , RA_PROFILE_TYPE , RA_PROFILE_GROUP , RA_PROFILE_UPDATE , 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 = 'ACT' AND RA_ONE_OR_MANY <> 'M'

# 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

5 RA_PROFILE_UPDATE Character(1) VARCHAR2(1) NOT NULL Profile Updateable
A=Updates Allowed via App. Class
D=Update Direct through SQL
N=No Updates - Read Only

6 DESCR254 Character(254) VARCHAR2(254) NOT NULL Description of length 254

7 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

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

9 RA_PROFILE_RECNAME Character(15) VARCHAR2(15) NOT NULL Profile - record name

10 ROW_ADDED_DTTM DateTime(26) TIMESTAMP This is a datetime field for record creation.

11 ROW_ADDED_OPRID Character(30) VARCHAR2(30) NOT NULL ID of user who added the row.

12 ROW_LASTMANT_DTTM DateTime(26) TIMESTAMP The date and time that the row was last updated.

13 ROW_LASTMANT_OPRID Character(30) VARCHAR2(30) NOT NULL ID of user who last modified the row.

14 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.

15 SYNCDTTM DateTime(26) TIMESTAMP Synchronization Last Update Date Time

#	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
5	RA_PROFILE_UPDATE	Character(1)	VARCHAR2(1) NOT NULL	Profile Updateable A=Updates Allowed via App. Class D=Update Direct through SQL N=No Updates - Read Only
6	DESCR254	Character(254)	VARCHAR2(254) NOT NULL	Description of length 254
7	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
8	RA_ONE_OR_MANY	Character(1)	VARCHAR2(1) NOT NULL	Profile - One or Many M=Many rows N=One row
9	RA_PROFILE_RECNAME	Character(15)	VARCHAR2(15) NOT NULL	Profile - record name
10	ROW_ADDED_DTTM	DateTime(26)	TIMESTAMP	This is a datetime field for record creation.
11	ROW_ADDED_OPRID	Character(30)	VARCHAR2(30) NOT NULL	ID of user who added the row.
12	ROW_LASTMANT_DTTM	DateTime(26)	TIMESTAMP	The date and time that the row was last updated.
13	ROW_LASTMANT_OPRID	Character(30)	VARCHAR2(30) NOT NULL	ID of user who last modified the row.
14	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.
15	SYNCDTTM	DateTime(26)	TIMESTAMP	Synchronization Last Update Date Time