RA_PRFL_GRP_IDRA_PRFL_FLD_SEQRA_PRFL_RL_COLLANGUAGE_CDRA_PRFLGRPGD2RL(SQL View) |
Index Back |
|---|---|
Profile Group Defn RelatedLangSecond grid's related language table. Allow 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 , LANGUAGE_CD , RA_FLD_LBL FROM PS_RA_FLD_LBL_LNG WHERE RA_PRFL_RL_COL = 'R' |
| # | 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 | LANGUAGE_CD |
Character(3) | VARCHAR2(3) NOT NULL | Language Code |
| 5 | RA_FLD_LBL | Character(25) | VARCHAR2(25) NOT NULL | Field Label - this is used by Marketing |