FIELDNAMEPrompt Table: BN_834_MAP_EDIT
BN_834_FIELD_VALUEPrompt Table: %EDITTABLE
BN_834_FIELD_MAPPDEFFDTDefault Value: %date
N=Customer Data
S=Sample Data
Y=System Data
Default Value: N
Y/N Table Edit
Default Value: N
BN_834_MAP_TBL(SQL Table) |
Index Back |
|---|---|
HIPAA 834 EDI Mapping TableAllows the mapping of PeopleSoft codes (and those added by the customer) to the values required by the 834 EDI standard. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | FIELDNAME |
Character(18) | VARCHAR2(18) NOT NULL |
Field Name (see PSDBFIELD).
Prompt Table: BN_834_MAP_EDIT |
| 2 | BN_834_FIELD_VALUE |
Character(20) | VARCHAR2(20) NOT NULL |
Stores the original (unmapped) field value on the EDI 834 Mapping table.
Prompt Table: %EDITTABLE |
| 3 | BN_834_FIELD_MAPPD |
Character(20) | VARCHAR2(20) NOT NULL | Stores the mapped field value on the EDI 834 Mapping table. |
| 4 | EFFDT |
Date(10) | DATE NOT NULL |
Effective Date
Default Value: %date |
| 5 | BN_834_FLD_DESCR1 | Character(50) | VARCHAR2(50) NOT NULL | Stores the original field value description on the EDI 834 Mapping table. |
| 6 | BN_834_FLD_DESCR2 | Character(50) | VARCHAR2(50) NOT NULL | Stores the mapped field value description on the EDI 834 Mapping table. |
| 7 | DATA_TYPE_CD | Character(1) | VARCHAR2(1) NOT NULL |
Data Type CD
N=Customer Data S=Sample Data Y=System Data Default Value: N |
| 8 | DEFAULT_EDI_CD | Character(1) | VARCHAR2(1) NOT NULL |
Stores Indicator to mark a code as default for EDI Mapping in Transaction Map Table.
Y/N Table Edit Default Value: N |