BASE_RECNAMEPrompt Table: PSRECDEFN
REC_MAPPING_TYPEGTT=TAO to GTT
PTS=Ptools table without Prefix
RTB=Production to RTBL
SY2=Synonyms without Triggers
SY3=Installation
SYN=Base to Synonym
Prompt Table: PSRECDEFN
REC_MAPPING_TBL(SQL Table) |
Index Back |
|---|
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BASE_RECNAME |
Character(15) | VARCHAR2(15) NOT NULL |
Base record that enabled for the supplemental data.
Prompt Table: PSRECDEFN |
| 2 | REC_MAPPING_TYPE |
Character(3) | VARCHAR2(3) NOT NULL |
Record Mapping Type.
GTT=TAO to GTT PTS=Ptools table without Prefix RTB=Production to RTBL SY2=Synonyms without Triggers SY3=Installation SYN=Base to Synonym |
| 3 | RECNAME | Character(15) | VARCHAR2(15) NOT NULL |
Record (Table) Name (see PSRECDEFN).
Prompt Table: PSRECDEFN |
| 4 | REC_MAPPING_ID | Character(30) | VARCHAR2(30) NOT NULL | Record Name Mapping ID |