AP_ARC_VCH_HP_H(SQL Table) |
Index Back |
|---|---|
Voucher HIPAA Definition TableAll Voucher HIPAA related information is stored here. This is a child record to VOUCHER table. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  PSARCH_ID |
Character(8) | VARCHAR2(8) NOT NULL | Archive ID (see PSARCHTEMPLATE). |
| 2 | PSARCH_BATCHNUM |
Number(30,0) | DECIMAL(30) NOT NULL | Archive Batch Number |
| 3 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL |
Business Unit
Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT Prompt Table: SP_BUS_AP_NONVW |
| 4 | VOUCHER_ID |
Character(8) | VARCHAR2(8) NOT NULL | Voucher ID |
| 5 | ENTITY_ID_CODE | Character(3) | VARCHAR2(3) NOT NULL |
Entity Identified Code
2B=3rd Party PR=Payer |
| 6 | REF_ID_QUAL | Character(3) | VARCHAR2(3) NOT NULL |
Reference Identifier Qualifier
14=Master 18=Plan 2F=Invoice |
| 7 | REF_ID | Character(30) | VARCHAR2(30) NOT NULL | Reference Identifier |
| 8 | RECV_ID_QUAL | Character(2) | VARCHAR2(2) NOT NULL |
Identification Code Qualifier
1=D&B 9=D&B + Sfx EQ=Insurance FI=Tax ID XV=Plan ID |
| 9 | RECV_ID | Character(80) | VARCHAR2(80) NOT NULL | Identification Code |
| 10 | CONTACT_NAME | Character(50) | VARCHAR2(50) NOT NULL | The individual contact name associated with a given bank/counterparty. |
| 11 | COMM_QUAL | Character(2) | VARCHAR2(2) NOT NULL |
Contact Method
EM=Email FX=Fax TE=Telephone |
| 12 | COMM_NUM | Character(80) | VARCHAR2(80) NOT NULL | Contact Information |
| 13 | POLICY_TYPE | Character(3) | VARCHAR2(3) NOT NULL |
Policy Information Type
11=Account 1L=Policy CT=Contract IK=Invoice |
| 14 | POLICY_NUM | Character(30) | VARCHAR2(30) NOT NULL | Policy Information |
| 15 | START_DT | Date(10) | DATE | Start Date |
| 16 | END_DT | Date(10) | DATE | End Date |