FIELDNAMEN=Customer Data
S=Sample Data
Y=System Data
Default Value: Y
BN_834_MAP_EDIT(SQL Table) |
Index Back |
|---|---|
HIPAA 834 Mapping Edit TableContains the names (and other attributes) of fields that need to be mapped for the HIPAA 834 EDI file creation process: 1) FIELDNAME - name of the field object (i.e. COVRG_CD). 2) EDITTABLE - name of the table/view where the field code is defined (i.e. COVRG_CD_TBL). 3) FIELDLABEL - label to be displayed on search lists (i.e. "Coverage Code"). 4) FIELDNAME_DESCR - name of the field that contains the description of the code (i.e. DESCR). 5) EDITTABLE2 - name of the table where the code being mapped is stored (i.e. BN_SNAP_PLAN). There won't be a page to maintain this table. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | FIELDNAME |
Character(18) | VARCHAR2(18) NOT NULL | Field Name (see PSDBFIELD). |
| 2 | EDITTABLE | Character(15) | VARCHAR2(15) NOT NULL | Edit Table |
| 3 | FIELDLABEL | Character(30) | VARCHAR2(30) NOT NULL | Field Label |
| 4 | FIELDNAME_DESCR | Character(18) | VARCHAR2(18) NOT NULL | Fieldname Journal Line Descr |
| 5 | EDITTABLE2 | Character(15) | VARCHAR2(15) NOT NULL | Secondary Edit Table |
| 6 | DATA_TYPE_CD | Character(1) | VARCHAR2(1) NOT NULL |
Data Type CD
N=Customer Data S=Sample Data Y=System Data Default Value: Y |