Fee_Pay_Item_Fee_Tran_Assoc (ver21.4.0)

This table holds the association between the Fee_Payment_Item and Fee_Transaction tables

Column Name

Initial Version

Data Type

Description

Fee_Payment_Item_ID

21.4.0

Number(19,0)

The internal number and ID of the associated Fee_Payment_Item record. Indexed. Required.

Fee_Transaction_DCID

21.4.0

Number(19,0)

The internal number and DCID of the associated Fee_Transaction record. Indexed. Required.

ID

21.4.0

Number(19,0)

Unique sequential number generated by the application. Indexed. Required.

WhenCreated

21.4.0

Timestamp(6)

The date and time the record was created. Defaults to system date.

WhenModified

21.4.0

Timestamp(6)

The date and time the record was modified. Defaults to system date.

WhoCreated

21.4.0

Varchar2(100)

The user login that created the record. Defaults to the database user. Required.

WhoModified

21.4.0

Varchar2(100)

The user login that modified the record. Defaults to the database user. Required.

Copyright © 2021 PowerSchool Group LLC