Penn Computing

University of Pennsylvania
Penn Computing << go backback

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

ISC_BILLING_DETAIL Table - Data Element Index

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



Data element Definition
ACCOUNT_ID

Indexed - no
Format - char (8)
May be null - yes

For direct billings or Interfund charges, this field further qualifies the account number; otherwise, values likely default to ADMIN.

Values: 
List of values not available.

ACCOUNTING_PERIOD

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

The Accounting Period stated in MON-YY format. MON is the calendar month (stored in upper case), and YY is the calendar year. Note that the beginning and ending dates of an ACCOUNTING_PERIOD are not the same as the first and last day of the calendar month. 

Example: JUL-99 (July 1999, which occurs in fiscal year 2000). 

Values:
List of values not available.
CALENDAR_MONTH

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

The number that identifies the calendar month (or accounting period). 

Example: 01 (January); 11 (November). 

Values:
01        January
02        February
03        March
04        April
05        May
06        June
07        July
08        August
09        September
10        October
11        November
12        December
13        Adjustment period
CALENDAR_YEAR

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

The calendar year for the ACCOUNTING_PERIOD. The calendar year begins January 1 and ends December 31. Example: 1999 (the CALENDAR_YEAR for ACCOUNTING_PERIOD JUL-99). 
Values:
List of values not available.
COA_ACCOUNT

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

The seven segment values that comprise the 26-position Accounting Flexfield. The segments are COA_CNAC, COA_ORG, COA_BC, COA_FUND, COA_OBJECT, COA_PROGRAM, and COA_CREF. 

Example: 40042274525799519120021438.

See also COA_CNAC, COA_ORG, COA_BC, COA_FUND, COA_OBJECT, COA_PROGRAM, and COA_CREF.

Values:
List of values not available.
COA_BC

Indexed - no
Format - char (1)
May be null? no

The budgetary control character that represents the level at which funds availability checking occurs. 

COA_BC is the third segment of the Accounting Flexfield. 

Examples: 1 (CNAC/ORG/FUND Year-To-Date); T (All Funds Checks). 

Values:
0 Project-to-Date for capital projects
1 CNAC/ORG/FUND Year-To-Date
2 CNAC/ORG/FUND/CREF Year-To-Date
4 CNAC/ORG/FUND/CREF Project-to-Date
A Funds Check parent of 1
B Funds Check parent of 2
D Funds Check parent of 4
T All Funds Checks
COA_CNAC

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

The 3-character center Net Asset Class (NAC) code. The first two positions of the COA_CNAC identify the school or center. The last position identifies the Net Asset Class: 0 (Unrestricted); 1 (Temporarily Restricted); 2 (Permanently Restricted). 

COA_CNAC is the first segment of the Accounting Flexfield. 

Example: 880 (Medical center, Unrestricted) 

Values:
Refer to the CNAC_Codes table for values.
COA_CREF

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

The 4-character Center Reference code. This is an identifier uniquely defined by each school or center. 

COA_CREF is used to record information that is important to a school or center but is inappropriate for any other segment of the Accounting Flexfield. The value of the center Reference code is unique within a school or center. 

COA_CREF is the seventh and last segment of the Accounting Flexfield. 

See the definition for CENTER_REF_CODES / CENTER_REF_CODE. 

Examples: 4045 (Graduate Programs); 4091 (SAS Newsletter) 

Values:
Refer to the center_REF_CODES table for values.
COA_FUND

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

The 6-character fund number. A fund is the unique identifier for a specific set of financial resources that needs tracking or management. 

COA_FUND is the fourth segment of the Accounting Flexfield. 

Examples: 000000 (General Unrestricted Fund); 010201 (SAS: GEN FUND 1) 

Values:
Refer to the FUND_CODES table for values.
COA_OBJECT

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

The 4-character OBJECT code. Identifies the asset, liability, revenue, or expense. 

COA_OBJECT is the fifth segment of the Accounting Flexfield.

Examples: 5220 (EXTERNAL OFFICE SUPPLIES); 1149 (CASH SUSPENSE) 

Values:
Refer to the OBJECT_CODES table for values.
COA_ORG

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

The 4-character ORGANIZATION code. This is a subdivision of the University created for management purposes. 

An ORGANIZATION belongs to only one responsibility center, and its ORGANIZATION code is unique. That is, no two ORGANIZATIONs will have the same values for COA_ORG. 

COA_ORG is the second segment of the Accounting Flexfield.

Examples: 0702 (Wharton Finance); 0705 (Wharton Legal Studies) 

Values:
Refer to the ORG_CODES table for values.
COA_PROGRAM

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

The 4-character PROGRAM code. This is an activity or work process commonly defined across the University for tracking a PROGRAM's activity across schools and centers (or across organizations within a school or center).

COA_PROGRAM is the sixth segment of the Accounting Flexfield. 

Examples: 7311 (Alumni Relations); 0001 (Discretionary) 

Values:
Refer to the PROGRAM_CODES table for values.
COA_RESPONSIBLE_ORG

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

The 4-character code for the organization responsible for managing the fund. Many organizations may use the same fund, but only one organization -- the COA_RESPONSIBLE_ORG -- is accountable for managing the fund. Those who are authorized to access records for the COA_RESPONSIBLE_ORG for the fund may access all records for the fund, regardless of the value of the COA_ORG in the COA_ACCOUNT for the record. 

Examples: 0011 (NYC Penn Club); 0215 (French Institute). 

Values:
Refer to the ORG_CODES table for values.
CYCLE_END_DATE

Indexed - yes
Format - date
May be null? yes

The end date of the billing cycle for which the item was invoiced.

Values:
List of values not available.
CYCLE_START_DATE

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

The beginning date of the billing cycle for which the item was invoiced.

Values:
List of values not available.
DESC1

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

For transactions where Service ID is NET:OUTLET, NET:CS or NET:IP, this column will contain the appropriate Building Code; for NET:EMAIL service transactions, it will contain the relevant Penn ID; for NET:WEBHOST service transactions, it will contain the type of web hosting component being charged; for SEO:BACKITUP service transactions, it will contain the quantity of disk billed; for NET:LISTSERV service transactions, it will contain a description of either ‘Total Monthly Charge’ or ‘Initial List Setup Fee’, depending on the type of charge; for NET:TLD service transactions, it will contain the name of the person who requested the Third Level Domain name; for TSS:SRB service transactions, it will contain either a cnt of new licenses or the qty in GB of disk storage for the Secure Remote Backup service.

Values:
List of values not available.
DESC2

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

For transactions where Service ID is NET:OUTLET, NET:CS or NET:IP, this column will contain the appropriate location; for NET:EMAIL service transactions, it will contain the relevant full name; for NET:WEBHOST service transactions, it will contain the # of units for a particular component; for SEO:BACKITUP service transactions, it will contain an invoice number; for NET:LISTSERV service transactions, it will contain the List Contact, but only if the charge is for the Initial Setup fee; for NET:TLD service transactions, it will contain the type of one-time charge, if applicable.

Values:
List of values not available.
DESC3

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

For transactions where Service ID is NET:OUTLET, this column will contain a service order number if applicable; for NET:IP or NET:CS, the hostname will be populated; for NET:EMAIL service transactions, it will contain the email type; for SEO:BACKITUP service transactions, it will contain a system-assigned account number or department name; for NET:LISTSERV service transactions, it will contain the list start bill date, but only if the charge is for the Initial Setup fee.

Values:
List of values not available.
DESC4

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

For transactions where Service ID is NET:OUTLET, this column will contain a project number if applicable; for NET:IP, the device type and use type will be populated for charges prior to July 1, 2007 and for NET:CS, the chargetype/usetype-ratetype will be used; for NET:EMAIL service transactions, it will contain the charge type; for SEO:BACKITUP service transactions, it will contain location information.

Values:
List of values not available.
FISCAL_MONTH_SEQ

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

The month (or accounting period) of the fiscal year. This field is used for sorting.

Examples: 01 (July); 11 (May). See also FISCAL_YEAR 

Values:
01        July
02        August
03        September
04        October
05        November
06        December
07        January
08        February
09        March
10        April
11        May
12        June
13        Adjustment period
FISCAL_YEAR

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

The financial year in which the ACCOUNTING_PERIOD falls. Penn's fiscal year begins July 1 of one calendar year and ends June 30 of the next calendar year. 

Example: 2000 (fiscal year that began July 1, 1999, and ended June 30, 2000) 

Values:
List of values not available. 
INVOICE_DATE

Indexed - yes
Format - date
May be null? no

The date on which the invoice was created.

Values:
List of values not available.
ISC_INVOICE_NUMBER

Indexed - no
Format - number(7)
May be null? yes

Invoice Number from the ISC Billing System.

Values:
List of values not available.
ITEM

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

Identifies the item billed. For transactions where the Service_ID is NET:OUTLET, this will contain the outlet ID; for NET:CS or NET:IP, it will contain the IP number (use NET:CS for charges posted after July 1, 2007); for NET:EMAIL, it will contain the login ID; for NET:WEB HOST it will contain the site url; for SEO:BACKITUP, this will contain the type of service (BIU or BIUX) and the client number; for NET:LISTSERV, this will contain either the # of Lists for the aggregate Monthly Charge or the actual List Name if the charge is for the Initial Setup fee; for ASTT:SECSPACE, this will contain the space id; for NET:TLD, this will contain the third level domain name; for TSS:SRB, this will contain the department and number of secure remote backup licenses or storage amounts.

Values:
List of values not available.
SERVICE_ID

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

Indicates the type of service billed (e.g., NET:EMAIL, NET:CS or NET:IP, NET:OUTLET, ASTT:SECSPACE, TSS:SRB). The IP service was renamed to CS as of July 1, 2007, to more accurately describe the charges as being for Central Service fees.

Values:
SEO:BACKITUP
NET:EMAIL
NET:IP
NET:CS
NET:OUTLET
NET:WEBHOST
NET:TLD
NET:LISTSERV
ASTT:SECSPACE
TSS:SRB
START_BILL_DATE

Indexed - no
Format - date
May be null? yes

The date the service was first billed.

Values:
List of values not available.
STOP_BILL_DATE

Indexed - no
Format - date
May be null? yes

Stop Bill Date may be null, or, if not null, represents the date after which service was no longer billed.

Values:
List of values not available.
TRANSACTION_AMOUNT

Indexed - no
Format - number(8,2)
May be null? no

The amount billed, for this item, invoice and account and transaction date combination.

Values:
List of values not available.
TRANSACTION_DATE

Indexed - no
Format - date
May be null? no

The date the transaction was processed in the ISC Billing system.

Values:
List of values not available.

ISC_BILLING_DETAIL 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