Penn Computing

University of Pennsylvania
Penn Computing << go backback
FUND_BILLING_FREQ_CODES Table    Tables and Data Elements   General Ledger Home  Data Warehouse Home

FUND_BILLING_FREQ_CODES Table - Data Element Index

Select a data element to view its definition and its indexed, format, and null values.



Data element Definition

BILLING_CYCLE_TYPE


Indexed - no
Format - varchar2 (30)
May be null? yes

Code that describes the billing cycle.

Examples: Billing Cycle Days, First Day of the Month.

BILLING_FREQ_CODE



Indexed - no
Format - varchar2 (52)
May be null? no

Code that indicates how often, or on what schedule, the fund is billed.

Examples: AD (100% payment); PS (In advance by payment schedule).


Values:
20	AUTOMATIC; Q1 (JAN, APR, JUL, OCT)
21	AUTOMATIC; Q2 (FEB, MAY, AUG, NOV)
23	AUTOMATIC; Q3 (MAR, JUN, SEP, DEC)
24	INVOICE BY SCHEDULE
25	AUTOMATIC; BY SCHEDULE
AD	100% PAYMENT
CS	COST SHARE ACCOUNT
CT	CLINICAL TRIALS
FC	AUTOMATIC PAYMENT FOREIGN CURRENCY
M	MONTHLY REIMBURSEMENT
NI	NO INVOICE REQUIRED
PI	COORDINATE WITH PI
PS	IN ADVANCE BY PAYMENT SCHEDULE
Q1	QUARTERLY REIMBURSEMENT (JAN, APR, JUL, OCT)
Q2	QUARTERLY REIMBURSEMENT (FEB, MAY, AUG, NOV)
Q3	QUARTERLY REIMBURSEMENT (MAR, JUN, SEP, DEC)
QA	QUATERLY IN ADVANCE
SI	(Not used)

BILLING_FREQ_DESC


Indexed - no
Format - char (52)
May be null? yes

The description that corresponds to the BILLING_FREQ_CODE indicating how often, or on what schedule, the fund is billed.

Examples: 100% payment (AD); In advance by payment schedule (PS).


Values:
20	AUTOMATIC; Q1 (JAN, APR, JUL, OCT)
21	AUTOMATIC; Q2 (FEB, MAY, AUG, NOV)
23	AUTOMATIC; Q3 (MAR, JUN, SEP, DEC)
24	INVOICE BY SCHEDULE
25	AUTOMATIC; BY SCHEDULE
AD	100% PAYMENT
CS	COST SHARE ACCOUNT
CT	CLINICAL TRIALS
FC	AUTOMATIC PAYMENT FOREIGN CURRENCY
M	MONTHLY REIMBURSEMENT
NI	NO INVOICE REQUIRED
PI	COORDINATE WITH PI
PS	IN ADVANCE BY PAYMENT SCHEDULE
Q1	QUARTERLY REIMBURSEMENT (JAN, APR, JUL, OCT)
Q2	QUARTERLY REIMBURSEMENT (FEB, MAY, AUG, NOV)
Q3	QUARTERLY REIMBURSEMENT (MAR, JUN, SEP, DEC)
QA	QUATERLY IN ADVANCE
SI	(Not used)

EFFECTIVE_FROM_DATE


Indexed - no
Format - date
May be null? yes

The date from which the billing frequency code may be used.

EFFECTIVE_TO_DATE


Indexed - no
Format - date
May be null? yes

The date until which the billing frequency code may be used.


FUND_BILLING_FREQ_CODES Table    Tables and Data Elements   General Ledger Home  Data Warehouse Home

Questions about this page? Email us at da-staff@isc.upenn.edu

Information Systems and Computing
University of Pennsylvania
Information Systems and Computing, University of Pennsylvania