The CA VM:Account PERIODTE CURRENT file contains the costed accounting records from the beginning of the accounting period until yesterday. The PERIODTE CURRENT file is used to produce reports on costed data for the current accounting period. This information is represented to VMRGRW by the VMJAREC3 data definition table.
By default, VMRGRW uses the PERIODTE CURRENT file when FILE VMJAREC3 is the first statement in your control file. To run a report for an accounting period before the current period, code the FILE statement with the filename and filetype of the accounting file you want to use. For example:
FILE VMJAREC3 PERIODTE JULY.
The first 80 characters of each record in the PERIODTE CURRENT file contain information similar to what is in the raw CP accounting records in the RAWDATA $$yymmdd files. The last 160 characters of each record in the PERIODTE CURRENT file contain customer, package, project, and charge information.
The PERIODTE CURRENT file does not include CARDTYP 04 and 06 records because they are not costed.
The CA VM:Account System Administrator's Guide contains more information about the PERIODTE format of accounting records.
The following table contains descriptions of fields that are specific to most of the VMJAREC3 data definition tables.
Field Name | Start | Length | Display | Type | Default Column Header | Description |
---|---|---|---|---|---|---|
USERID | 1 | 8 | A/N | USERID | Virtual machine ID this record applies to | |
ACCOUNT | 9 | 8 | A/N | ACCOUNT | Virtual machine accounting number from the VM user directory this record applies to | |
ENDDATE | 17 | 6 | 099/99/99 | Z/D | END DATE | Ending date of accounting period (yymmdd) |
ENDTIME | 23 | 6 | 099:00:00 | Z/D | END TIME | Ending time of accounting period (hhmmss) |
RECTYP | 75 | 2 | A/N | REC TYPE | Record type code for records created by CA VM:Account | |
TRANTYP | 77 | 2 | A/N | TRAN TYPE | Transaction type | |
CARDTYP | 79 | 2 | A/N | CARD TYPE | Accounting record datatype code Literal values for CARDTYPL work field: '01'='SESSION ' '02'='DEDICATED DEVICE' '03'='TDISK SPACE ' '04'='INVALID LOGON ' '05'='LINKS ' '06'='INVALID LINK ' '07'='VSCS ' '08'='LOGOFF ' 'A3'='VOLUMES ' 'A4'='MINIDISK ' 'A5'='MISCELLANEOUS ' 'A6'='TAPE MOUNTS ' 'A7'='RSCS ' 'A9'='VM:ARCHIVER ' 'AA'='SQL/DS ' 'AB'='VM:SPOOL ' 'AC'='TSAF ' 'AD'='SQL/DS DBSPACE ' 'AE'='SFS USAGE ' 'AF'='SFS DASD ' 'DE'='DOS/VSE EXECUTE' 'DL'='DOS/VSE LIST ' | |
VRECTYPE | 81 | 2 | A/N | REC TYPE | CA VM:Account record type code | |
UEXITFLG | 83 | 1 | XX | BIT | USER EXIT FLAGS | User exit flags. Values: X'01'=The RAWDATA user exit modified the record X'02'=The ACCTDATA user exit modified the record X'04'=The COSTING user exit modified the record X'08'=This is a user record entirely costed by the COSTING user exit |
DATAFLAG | 84 | 1 | XX | BIT | DATA FLAGS | Billing/data flags. Values: X'01'=The system is configured for CHGCUST PROJECT X'02'=The system is configured for CHGCUST ACCOUNT X'10'=The charges were part of a CA VM:Batch job X'20'=CA VM:Batch marked as of RJE origin X'80'=The data has been recosted |
SURCHFLG | 85 | 1 | XX | BIT | SURCHARGE FLAGS | Surcharge flags. Values: X'01'=Surcharging for a specific day X'02'=Surcharging for a holiday X'10'=Surcharging for a package X'20'=Surcharging for a batch job X'80'=Surcharging for a CA VM:Batch job; this flag and X'20' are mutually exclusive |
WEEKDAY | 86 | 1 | A/N | DAY OF WEEK | A value from 1-7; Sunday corresponds to 1 | |
BEGDATE | 87 | 6 | 099/99/99 | Z/D | BEGIN DATE | Beginning date of accounting period (yymmdd) |
BEGTIME | 93 | 6 | 099:99:99 | Z/D | BEGIN TIME | Beginning time of accounting period (hhmmss) |
SHIFT | 99 | 8 | A/N | SHIFT ID | Shift-id | |
NODE | 107 | 8 | A/N | NODE | The ID of the node on which the job ran | |
CUSTOMER | 123 | 12 | A/N | CUSTOMER NUMBER | Customer number this record applies to | |
PROJECT | 135 | 24 | A/N | PROJECT | Project this record applies to | |
PACKAGE | 159 | 8 | A/N | PACKAGE | Package this record applies to | |
LINKCODE | 167 | 8 | A/N | LINK CODE | Original account number that exists in raw data file | |
LINKBYTE | 167 | 1 | XX | BIT | LINK BYTE | Flag to indicate if the account number field has been encoded |
PROJIND2 | 168 | 3 | 99909 | BINP | PROJ INDEX | Project index; this corresponds to the index stored in the PROJECTS MASTER file |
PACKIND2 | 171 | 2 | 99909 | BINP | PACKG INDEX | Package index; this corresponds to the index stored in the PACKAGES MASTER file |
JOBNO | 173 | 2 | 99909 | BINP | BATCH JOB NUM | CA VM:Batch job number |
JOBNAME | 175 | 8 | A/N | VMBATCH JOB NAME | CA VM:Batch job name | |
JOBCLASS | 183 | 1 | A/N | VMBATCH JOB CLASS | CA VM:Batch job class | |
JOBPRIOR | 184 | 1 | 909 | BINP | VMBATCH JOB PRIOR | CA VM:Batch job priority |
The remaining tables present descriptions of fields that are specific to a particular datatype (that is, a particular CARDTYP).