RY_PROF_ACT_VW (SQL View)	Index Back
All Profiles with Active field For Variable Content - Capture all profiles with an active profile field. For Design-side Tree

RY_PROF_ACT_VW

(SQL View)

All Profiles with Active field

For Variable Content - Capture all profiles with an active profile field. For Design-side Tree

SELECT A.RA_PROFILE_ID , A.RA_PROFILE_NAME , A.RA_PROFILE_TYPE , A.RA_PROFILE_GROUP , A.DESCR254 , A.RA_PROFILE_STATUS , A.RA_ONE_OR_MANY , A.RA_AUTO_CREATE_TBL , A.RA_PROFILE_RECNAME , A.RA_PROFILE_UPDATE , A.PRCSINSTANCE , A.ROW_ADDED_DTTM , A.ROW_ADDED_OPRID , A.ROW_LASTMANT_DTTM , A.ROW_LASTMANT_OPRID ,A.SYNCID ,A.SYNCDTTM FROM PS_RA_PROFILE A WHERE A.RA_PROFILE_ID IN ( SELECT RA_PROFILE_ID FROM PS_RA_ATTR_ACT_VW)

# 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
Default Value: 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_AUTO_CREATE_TBL Character(1) VARCHAR2(1) NOT NULL Field to indicate whether or not to auto create profile.
N=Create/Map Profile Manually
Y=Create Profile Automatically
Default Value: Y

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

10 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
Default Value: D

11 PRCSINSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance

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

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

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

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

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

17 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 Default Value: 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_AUTO_CREATE_TBL	Character(1)	VARCHAR2(1) NOT NULL	Field to indicate whether or not to auto create profile. N=Create/Map Profile Manually Y=Create Profile Automatically Default Value: Y
9	RA_PROFILE_RECNAME	Character(15)	VARCHAR2(15) NOT NULL	Profile - record name
10	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 Default Value: D
11	PRCSINSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
12	ROW_ADDED_DTTM	DateTime(26)	TIMESTAMP	This is a datetime field for record creation.
13	ROW_ADDED_OPRID	Character(30)	VARCHAR2(30) NOT NULL	ID of user who added the row.
14	ROW_LASTMANT_DTTM	DateTime(26)	TIMESTAMP	The date and time that the row was last updated.
15	ROW_LASTMANT_OPRID	Character(30)	VARCHAR2(30) NOT NULL	ID of user who last modified the row.
16	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.
17	SYNCDTTM	DateTime(26)	TIMESTAMP	Synchronization Last Update Date Time