RA_PRFL_GRP_IDRA_PRFL_FLD_SEQRA_PRFL_RL_COLRA_PRFL_GRP_GD1(SQL View) |
Index Back |
|---|---|
Profile Group DefinitionFirst grid. Allows setup for profile fields to be displayed on left hand side column, when displayed on CDM components. |
| SELECT RA_PRFL_GRP_ID , RA_PRFL_FLD_SEQ , RA_PRFL_RL_COL , RA_PROFILE_ID , RA_ATTRIBUTE_ID , RA_FLD_LBL FROM PS_RA_PRFL_GRP_FLD WHERE RA_PRFL_RL_COL = 'L' |
| # | 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_FLD_SEQ |
Number(2,0) | SMALLINT NOT NULL | Profile Field Sequence |
| 3 | RA_PRFL_RL_COL |
Character(1) | VARCHAR2(1) NOT NULL | Profile Column - this is used by Marketing |
| 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 |