RA_PRFL_GRP_IDRA_PRFL_RL_COLRA_PRFL_FLD_SEQRA_GRP_FLDMC_VW(SQL View) |
Index Back |
|---|---|
Profile Groop securityprofile group security by marketing center view- |
| SELECT A.RA_PRFL_GRP_ID ,A.RA_PRFL_RL_COL , A.RA_PRFL_FLD_SEQ ,A.RA_PROFILE_ID ,A.RA_ATTRIBUTE_ID ,A.RA_FLD_LBL , B.OPRID FROM PS_RA_PRFL_GRP_FLD A ,PS_RA_PRF_SCRTY_VW B WHERE A.RA_PROFILE_ID = B.RA_PROFILE_ID |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | RA_PRFL_GRP_ID |
Number(18,0) | DECIMAL(18) NOT NULL | Profile Group ID - this is used by Marketing |
| 2 | RA_PRFL_RL_COL |
Character(1) | VARCHAR2(1) NOT NULL | Profile Column - this is used by Marketing |
| 3 | RA_PRFL_FLD_SEQ |
Number(2,0) | SMALLINT NOT NULL | Profile Field Sequence |
| 4 | RA_PROFILE_ID | Number(18,0) | DECIMAL(18) NOT NULL | Profile - profile ID |
| 5 | RA_ATTRIBUTE_ID | Number(18,0) | DECIMAL(18) NOT NULL | Profile / Attribute ID |
| 6 | RA_FLD_LBL | Character(25) | VARCHAR2(25) NOT NULL | Field Label - this is used by Marketing |
| 7 | OPRID | Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |