RA_CMPT_TYPECPNY=Company
PRSN=Person
PTNR=Partner
SCPN=Sales Company
SPRS=Sales Person
TELM=TeleSales
WRKR=Worker
RA_CMPT_PG_TYPEMAIN=Main
PRFL=Profile Info
RA_PRFL_GRP_SEQY/N Table Edit
RA_CMPT_PRFL_G2(SQL View) |
Index Back |
|---|---|
Component Profile Group Grid-2Second grid on Component - Profile Group assigning page. |
| 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 = 'PRFL' |
| # | 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 |