RA_PROFILE_IDPrompt Table: RA_PROFILE
RA_ATTRIBUTE_IDPrompt Table: RA_ATTRIBUTE
RA_CHOICE_IDRA_CHOICE_PAREN_IDLANGUAGE_CDRA_ATTR_CHC_LNG(SQL Table) |
Index Back |
|---|---|
Attribute Choice Related Lang.Related Language record for attribute choices. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | RA_PROFILE_ID |
Number(18,0) | DECIMAL(18) NOT NULL |
Profile - profile ID
Prompt Table: RA_PROFILE |
| 2 | RA_ATTRIBUTE_ID |
Number(18,0) | DECIMAL(18) NOT NULL |
Profile / Attribute ID
Prompt Table: RA_ATTRIBUTE |
| 3 | RA_CHOICE_ID |
Character(50) | VARCHAR2(50) NOT NULL | Profile Attribute Choice ID |
| 4 | RA_CHOICE_PAREN_ID |
Character(50) | VARCHAR2(50) NOT NULL | Profile Attribute Parent Choice ID. This field is used for creating parent child relationship, which helps in dropdown filtering. |
| 5 | LANGUAGE_CD |
Character(3) | VARCHAR2(3) NOT NULL | Language Code |
| 6 | RA_CHOICE_LABEL | Character(50) | VARCHAR2(50) NOT NULL | Choice Label name |