VOUCHER_HIPAA

(SQL Table)
 Index Back

Voucher HIPAA Definition Table

All Voucher HIPAA related information is stored here. This is a child record to VOUCHER table.

  • Parent record: VOUCHER

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

    Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT

    Prompt Table: SP_BUS_AP_NONVW

    2 VOUCHER_ID Character(8) VARCHAR2(8) NOT NULL Voucher ID
    3 ENTITY_ID_CODE Character(3) VARCHAR2(3) NOT NULL Entity Identified Code
    2B=3rd Party
    PR=Payer
    4 REF_ID_QUAL Character(3) VARCHAR2(3) NOT NULL Reference Identifier Qualifier
    14=Master
    18=Plan
    2F=Invoice
    5 REF_ID Character(30) VARCHAR2(30) NOT NULL Reference Identifier
    6 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
    7 RECV_ID Character(80) VARCHAR2(80) NOT NULL Identification Code
    8 CONTACT_NAME Character(50) VARCHAR2(50) NOT NULL The individual contact name associated with a given bank/counterparty.
    9 COMM_QUAL Character(2) VARCHAR2(2) NOT NULL Contact Method
    EM=Email
    FX=Fax
    TE=Telephone
    10 COMM_NUM Character(80) VARCHAR2(80) NOT NULL Contact Information
    11 POLICY_TYPE Character(3) VARCHAR2(3) NOT NULL Policy Information Type
    11=Account
    1L=Policy
    CT=Contract
    IK=Invoice
    12 POLICY_NUM Character(30) VARCHAR2(30) NOT NULL Policy Information
    13 START_DT Date(10) DATE Start Date
    14 END_DT Date(10) DATE End Date