Populating the INTFC_BI_NOTE Table

This topic provides an overview of the INTFC_BI_NOTE table and discusses how to populate the INTFC_BI_NOTE table.

The Billing Interface Note/Comment table (INTFC_BI_NOTE) contains the text of nonstandard notes and comments. Each record corresponds to a record on the INTFC_BI table having a transaction type of NOTE. The following four attributes comprise the key to the INTFC_BI_NOTE table:

Term

Definition

INTFC_ID (interface ID)

Represents a group or batch of billing activity—that is, a collection of billing activity that may be produced by a billing source system. For example, a system may generate a group or batch each night, while another may produce a group or batch for a certain kind of billing activity.

INTFC_LINE_NUM (interface line number)

With INTFC_ID, identifies the NOTE record on the INTFC_BI table to which this note entry applies.

TRANS_TYPE_BI (transaction type billing)

Characterizes the type of data being stored. NOTE (custom note or comment) is the only valid option.

TRANS_TYPE_BI_SEQ (transaction type billing sequence)

Part of the key that provides uniqueness in the event that there are multiple notes or comments for a bill line charge.

The INTFC_BI_NOTE table has the same key structure as the INTFC_BI table; consider it an extension of the INTFC_BI table. In addition to the key fields, the table contains one additional column: TEXT254. Populate this table to pass nonstandard notes along with an interface transaction line. The TEXT254 column is used to hold the note text. The value of the TRANS_TYPE_BI column for the INTFC_BI_NOTE table must be NOTE.

For every row in INTFC_BI_NOTE, there must exist a row in INTFC_BI with the same key values. You do not, however, need a row in INTFC_BI_NOTE for every row in INTFC_BI.

If you are passing standard notes (the note is already predefined in the PeopleSoft Billing system), you do not need to pass an associated INTFC_BI_NOTE row. Specify the note code in the STD_NOTE_CD column.

If you elect to pass a nonstandard note in INTFC_BI_NOTE, the associated row in INTFC_BI must have the standard note code column (STD_NOTE_CD) set to blank.

The following table demonstrates how to populate the INTFC_BI_NOTE table:

Field Number

Field

NOTE

1

INTFC_ID (interface ID)

Required. Used to group or batch a collection of Billing interface activity.

2

INTFC_LINE_NUM (interface line number)

Required. Each unique interface line number for an interface ID represents a separate bill line charge.

3

TRANS_TYPE_BI (transaction type)

Required. Value must be NOTE.

4

TRANS_TYPE_BI_SEQ (transaction type sequence)

Required. If more than one note is populated for a particular LINE transaction, the transaction type sequence must be used for uniqueness.

Note: For note transactions, do not initialize TRANS_TYPE_BI_SEQ to zero. For note transactions, TRANS_TYPE_BI_SEQ must begin with 1.

5

PROCESS_INSTANCE

Leave blank.

6

TEXT254 (note text)

Required if standard note (STD_NOTE_CD) is left blank on the associated row in INTFC_BI.

7

ADD_DTTM

Required for accurate reporting purposes and for taking advantage of interface workflow function.

8

LAST_UPDATE_DTTM

Leave blank.