PSOPA_ENTFLDMAP(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 | OPA_FIELD_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Attribute Type
B=Input/Output I=Input O=Output |
6 | OPA_SEQ_NBR | Number(3,0) | SMALLINT NOT NULL | Sequence Number |
7 | OPA_FIELDNAME | Character(36) | VARCHAR2(36) NOT NULL | OPA Attribute |
8 | DESCR254 | Character(254) | VARCHAR2(254) NOT NULL | Description of length 254 |
9 | OPA_ATRREQ_TYPE | Character(2) | VARCHAR2(2) NOT NULL |
Attribute Data Type
01=Number 02=Date 03=Text 04=Boolean 05=Date Time 06=Time 07=Currency |
10 | OPA_ATRRESP_TYPE | Character(2) | VARCHAR2(2) NOT NULL |
Response Data Type
01=value-only 02=decision-report |
11 | OPA_USER_DEFINED | Character(1) | VARCHAR2(1) NOT NULL |
User Defined
N=No Y=Yes Default Value: Y |
12 | LAST_UPDATE_DTTM | DateTime(26) | TIMESTAMP | Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts. |