RA_PRFL_GRP_FLD(SQL Table) |
Index Back |
|---|---|
Profile Group Fields RecordProfile Group Fields, records the profile fields in a Profile Group. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | Number(18,0) | DECIMAL(18) NOT NULL | Profile Group ID - this is used by Marketing | |
| 2 | Character(1) | VARCHAR2(1) NOT NULL | Profile Column - this is used by Marketing | |
| 3 | 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 |