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_FREQ_CODE



Indexed - no
Format - char (2)
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)

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