OPA_DATAMODEL_IDOPA_ENTITY_NAMERECNAMEPrompt Table: OPA_ENTREC_VW
FIELDNAMEPrompt Table: OPA_RECFLD_VW
LANGUAGE_CDPSOPA_FDMP_LANG(SQL Table) |
Index Back |
|---|---|
OPA Entity Field MappingOPA Entity Field Mapping |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | OPA_DATAMODEL_ID |
Character(40) | VARCHAR2(40) NOT NULL | Data Model ID |
| 2 | OPA_ENTITY_NAME |
Character(50) | VARCHAR2(50) NOT NULL | Entity Name |
| 3 | RECNAME |
Character(15) | VARCHAR2(15) NOT NULL |
Record (Table) Name (see PSRECDEFN).
Prompt Table: OPA_ENTREC_VW |
| 4 | FIELDNAME |
Character(18) | VARCHAR2(18) NOT NULL |
Field Name (see PSDBFIELD).
Prompt Table: OPA_RECFLD_VW |
| 5 | LANGUAGE_CD |
Character(3) | VARCHAR2(3) NOT NULL | Language Code |
| 6 | DESCR254 | Character(254) | VARCHAR2(254) NOT NULL | Description of length 254 |