SUMMARY OF RECORD FORMATS IN NEW VERSION OF "ALL" CUMULATIVE CHARGE FILE (by John Osudar; 22-Jul-1986) Purpose of ALL file ------------------- The ALL file contains all accumulated charges for a particular accounting period (month, year, etc.) It includes both the resource usage (e.g. CPU-hours, megabyte-days) and cost in dollars (based upon rates that were in effect when the charges were incurred.) Types of records ---------------- The record type is a single-character field within the data record, containing a single hexadecimal digit, which represents the record type. The following record types are currently defined: type purpose ---- ------- 0 cost center surcharges and other automatic adjustments 1 disk usage charges 2 monthly user account charges 3 monthly port charges 4 miscellaneous itemized charges 5 CPU and connect time charges 6 image usage surcharges 7 (unused -- record is ignored) 8 printer usage charges 9 (reserved for future use) A (reserved for future use) B (reserved for future use) C credit (charge limit) D debit (cumulative total charge) E (reserved for future use) F adjustments Record formats -- general ------------------------- Each record within the ALL file has the same basic structure. Some fields, particularly within the primary key, are identical in all records, while others are specific to one or more record types. The key field of a record consists of the first 64 characters. This field is required to contain the following information in its first 13 columns: columns 1-12 costcode, in "flipped" format (i.e. "xxxxx-yy-zzz" is represented as "zzzxxxxx-yy-") column 13 record type character Subsequent columns within the key field depend upon the type of record. All cost amounts are expressed as real numbers in a 20-column non-exponential format containing a floating decimal point. These numbers are expected to be used in calculations with the D_floating datatype. Other real values can be stored using the same format; these are indicated below as "Dfloat format". Record formats -- specific -------------------------- The following describes the record formats used for each type of record. Type 0 -- cost center surcharges and other automatic adjustments (maximum record length = 84) columns 14-64 unused (must be blank) columns 65-84 amount of surcharge Type 1 -- disk usage charges (maximum record length = 190) columns 14-41 first 28 characters of directory for which charges were recorded (exclude "[" and "]"; if more than 28 characters would be required, replace 28th with "*") columns 42-47 nodename where disk is located columns 48-64 logical volume name of disk device for which charges are recorded columns 65-79 file number and sequence number of charged directory columns 80-99 number of megabyte-days of disk usage for latest versions of files (Dfloat format) columns 100-119 charges for disk usage for latest versions columns 120-139 number of megabyte-days of disk usage for older versions of files (Dfloat format) columns 140-159 charges for disk usage for older versions columns 160-end name of account owner (deduced from top-level directory and retrieved from SYSUAF on node); if none found, field is blank or not present Type 2 -- monthly user account charges (maximum record length = 115) columns 14-25 username for which charges are recorded columns 26-31 nodename where account is located columns 32-64 (unused -- must be blank) columns 65-84 charges for user account maintenance columns 85-end name of account owner (from SYSUAF on node); if none known, field is blank or not present Type 3 -- monthly port charges (maximum record length = 170) columns 14-19 nodename where port is located columns 20-34 name of port columns 35-64 (unused -- must be blank) columns 65-84 charges for dedicated port columns 85-end comment (up to 86 characters long) Type 4 -- miscellaneous itemized charges (maximum record length = 176) columns 14-21 date when charge was logged (yyyymmdd) columns 22-37 sequence number for this charge (use hexadecimal sixteen-digit time when record written) columns 38-64 (unused -- must be blank) columns 65-84 charge amount columns 85-end comment (up to 92 characters long) Type 5 -- CPU and connect time charges (maximum record length = 255) columns 14-25 username for which charges were recorded columns 26-31 nodename on which charges were accumulated column 32 rate type for which charges were recorded (a single hexadecimal digit -- currently, the only ones used are: 0 = prime time at old rate 1 = nonprime time at old rate 2 = prime time at new/current rate 3 = nonprime time at new/current rate) columns 33-64 (unused -- must be blank) columns 65-84 high priority CPU time used (in hours -- Dfloat format) columns 85-104 charge for high priority CPU time used columns 105-124 medium priority CPU time used (in hours -- Dfloat format) columns 125-144 charge for medium priority CPU time used columns 145-164 low priority CPU time used (in hours -- Dfloat format) columns 165-184 charge for low priority CPU time used columns 185-204 connect time (in hours -- Dfloat format) columns 205-224 charge for connect time columns 225-end name of account owner (from SYSUAF on node); if not known, field is blank or not present Type 6 -- image usage surcharges/discounts (maximum record length = 247) columns 14-45 first 32 characters of name of image for which surcharge was recorded columns 46-57 username for which charges were recorded columns 58-63 nodename on which charges were accumulated column 64 rate type for which charges were recorded (a single hexadecimal digit -- currently, the only ones used are: 0 = prime time at old rate 1 = nonprime time at old rate 2 = prime time at new/current rate 3 = nonprime time at new/current rate) columns 65-76 number of times image was run (I12 format) columns 77-96 per-run charge for image use columns 97-116 high priority CPU time used (in hours -- Dfloat format) columns 117-136 charge for high priority CPU time used columns 137-156 medium priority CPU time used (in hours -- Dfloat format) columns 157-176 charge for medium priority CPU time used columns 177-196 low priority CPU time used (in hours -- Dfloat format) columns 197-216 charge for low priority CPU time used columns 217-end name of account owner (from SYSUAF on node); if not known, field must be blank or not present Type 8 -- printer usage charges (maximum record length = 127) columns 14-44 name of queue for which charges were accumulated columns 45-56 username for which charges were recorded columns 57-62 nodename on which charges were accumulated columns 63-64 (unused -- must be blank) columns 65-76 number of lines printed (in I12 format) columns 77-96 charge for printing columns 97-end name of account owner (from SYSUAF on node) Type C -- credit (charge limit) (maximum record length = 216) columns 14-29 hexadecimal sixteen-digit time when record written columns 30-64 (reserved for future use -- must be blank) columns 65-84 allocation amount columns 85-end comment (up to 132 characters long) Type D -- debit (cumulative charge total) (maximum record length = 162) columns 14-29 hexadecimal sixteen-digit time when record written columns 30-57 (reserved for future use -- must be blank) columns 58-64 accounting month and year for which record written (mmmyyyy) columns 65-84 charge total amount columns 85-end comment or title from accounting report (up to 78 characters long) Type F -- adjustments (maximum record length = 175) columns 14-21 date when adjustment was logged (yyyymmdd) columns 22-37 sequence number for this adjustment (use hexadecimal sixteen-digit time when record written) columns 38-64 (unused -- must be blank) columns 65-76 costcode from which adjustment transferred, if any columns 77-96 adjustment amount columns 97-end comment (up to 79 characters long)