RA_CMPT_PRFL_GD

(SQL View)
 Index Back

Component Profile Group Grid

Component Profile Group Grid record. With profile group ID as a related field.

SELECT RA_CMPT_TYPE , RA_CMPT_PG_TYPE , RA_PRFL_GRP_SEQ , RA_PRFL_GRP_ID , RA_CLA_COND_ID , RA_GRP_READ_ONLY FROM PS_RA_CMPT_PRFL WHERE RA_CMPT_PG_TYPE = 'MAIN'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 RA_CMPT_TYPE Character(4) VARCHAR2(4) NOT NULL Component Type for use by Profile Groups
CPNY=Company
PRSN=Person
PTNR=Partner
SCPN=Sales Company
SPRS=Sales Person
TELM=TeleSales
WRKR=Worker
2 RA_CMPT_PG_TYPE Character(4) VARCHAR2(4) NOT NULL Component Page Type
MAIN=Main
PRFL=Profile Info
3 RA_PRFL_GRP_SEQ Number(3,0) SMALLINT NOT NULL Profile Group Sequence - this is used by Marketing
4 RA_PRFL_GRP_ID Number(18,0) DECIMAL(18) NOT NULL Profile Group ID - this is used by Marketing
5 RA_CLA_COND_ID Number(31,0) DECIMAL(31) NOT NULL CLA condition ID - this is used by Marketing
6 RA_GRP_READ_ONLY Character(1) VARCHAR2(1) NOT NULL Read Only Group - this is used by Marketing

Y/N Table Edit