| Data Columns | Computed Columns |
| Adapter | CA TMS |
|---|---|
| Computer Associates CA1 Tape Management System. Data on tape data sets and volumes in z/OS environments. | |
| Domain Category | TMS |
| ITRM Table Name | XTMS |
| MXG Table Name | TMS |
| Table Description | TMS (CA-1) volume record |
Data Columns
| ITRM Column Name | MXG Column Name  | Description |
|---|---|---|
| ABN | ABN | VolumeClosedByAbend? |
| ACCT | ACCT | UserJobAccountingArea |
| ACTVOL | ACTVOL | ActualPhysicalWhereVirtualOffloaded |
| ADLFILS | ADDLFILS | AdditionalFilesExistInVolset? |
| BADTAP | BADTAP | BadTape? |
| BATCHID | BATCHID | BatchUpdateIdNumber |
| BESKEY | BESKEY | TapeEncryptionKeyIndex |
| BLKCNT | BLKCNT | TapeBlockCount |
| BLKSIZE | BLKSIZE | PhysicalBlockSize(bytes) |
| BTHDATE | BTHDATE | TapeBirthDate |
| CAT | CAT | MvsCatalogUsedForThisAccess? |
| CDDNAME | CDDNAME | CreatingDdname |
| CJOB | CJOB | TapeCreatedByJob |
| CLN | CLN | TapeIsToBeCleaned? |
| CLNCNT | CLNCNT | NumTimesCleaned |
| CLO | CLO | VolumeClosedByTms? |
| COMPRES | COMPRES | SpaceSavedDueToIdrcCompressPct |
| COPYCAT | COPYCAT | CreatedByCopycat? |
| COUNT | COUNT | TapeOpenCount |
| CPGM | CPGM | CreatingProgramName |
| CREATIM | CREATIME | TapeCreateDatetime |
| CRTDT | CRTDT | TapeCreateDate |
| CTLGCNT | CTLGCNT | NrTimesDatasetWasUncataloged |
| CUNIT | CUNIT | FirstDriveUsed |
| DATECLN | DATECLN | TapeCleanedLast |
| DATETIME | DATETIME | Datetime |
| DEF | DEF | DefaultExpirationUsed? |
| DEFEXPO | DEFEXPOO | DefaultExpdtUsedAtOpenOutput? |
| DEGAUSD | DEGAUSSD | TapeHasBeenDegaussed? |
| DEL | DEL | VolumeDeletedFromLibrary? |
| DEN | DEN | TapeDensity |
| DEVTYPE | DEVTYPE | Devtype |
| DSN | DSN | DataSetName |
| DSN17 | DSN17 | Last17BytesOfDataSetName |
| DSBFEET | DSNBFEET | FeetOfTapeForThisDataset |
| DSNBYTE | DSNBYTES | BytesInThisDataset |
| DSSFLAG | DSSFLAG | InternalFlagsForPasswrd |
| DYNAM | DYNAM | Dynam? |
| E99 | E99 | ExpiredBy99000? |
| ECC | ECC | ExpiredBy99ccc? |
| EDD | EDD | ExpiredBy98ddd? |
| EDMID | EDMID | ExternalDataManagerId |
| EDMTAP | EDMTAP | EdmTape? |
| EMVREL | EMVREL | ReleasedByExternalVaultManager? |
| ERSEREQ | ERASEREQ | DatasetEraseRequired? |
| ETM | ETM | ExpiredByTms? |
| EXPDT | EXPDT | TapeExpirationDate |
| FILECNT | FILECNT | CountOfDsnbrecsFound |
| FILISCA | FILEISCA | FileOnOsCatalog? |
| FILPERC | FILPERC | PhysicalSpaceUsedByFilePct |
| FISDSNB | FIRSDSNB | AddressOfFirstDsnb |
| FIRSTVO | FIRSTVOL | FirstVolume |
| FLAG3 | FLAG3 | InternalFlagBitsThree |
| FLAG4 | FLAG4 | InternalFlagBitsFour |
| INT | INT | InternalFieldChangedByUser? |
| IRG | IRG | InterRecordGap(in.) |
| LABEL | LABEL | TapeLabelType |
| LATDSNB | LASTDSNB | AddressOfLastDsnb |
| LATTIME | LASTTIME | DatetimeLastUsed |
| LDATE | LDATE | TapeUsedLast |
| LJOB | LJOB | JobUsedLast |
| LPGM | LPGM | LastUsedProgramName |
| LRECL | LRECL | LogicalRecordLength |
| LSTPDATE | LSTPDATE | LastProcessDate |
| LUNIT | LUNIT | LastDriveUsed |
| NEXTVOL | NEXTVOL | NextVolumeSerial |
| NUMDSNB | NUMDSNB | NrOfDsnbDsNameBlocks |
| OUT | OUT | DataSetOpenedForOutput? |
| OUTCODE | OUTCODE | Out-ofAreaCode |
| OUTDATE | OUTDATE | DateTapeRemoved |
| PASSWRD | PASSWRD | Password |
| PRERRC | PRERRC | PermanentReadErrorClean |
| PRERRI | PRERRI | PermanentReadErrorInit |
| PREVVOL | PREVVOL | PrevVolumeSerial |
| PWERRC | PWERRC | PermanentWriteErrorClean |
| PWERRI | PWERRI | PermanentWriteErrorInit |
| REC | REC | DataSetRecreated? |
| RECFM | RECFM | RecordFormat |
| ROBID | ROBID | TapeInRoboticDevice(userField) |
| ROBTY | ROBTY | RoboticDeviceIndicator(userField) |
| SCR | SCR | TapeListedOnScratchList? |
| SLOT | SLOT | VaultSlotNumber |
| SMSXPIR | SMSEXPIR | ExpiredBySmsMaxRetention? |
| SMSMC | SMSMC | SmsManagementClass |
| STPNAME | STPNAME | CreatedByStepName |
| TAPEBYT | TAPEBYTE | EstimatedBytesOnThisTape |
| TAPFEET | TAPEFEET | EstimatedFeetOfTapeUsed |
| TEM | TEM | TemporaryDataSet? |
| TMUBTCH | TMAUBTCH | BatchUpdateIdNumber |
| TMUCODE | TMAUCODE | AuditCodeOfRecord |
| TMAUCPU | TMAUCPU | Cpuid |
| TMUDATE | TMAUDATE | DateOfLastAudit |
| TMUFLG1 | TMAUFLG1 | AuditFlag |
| TMUHOOK | TMAUHOOK | IdNumberOfLastHook |
| TMUTIME | TMAUTIME | TimeOfLastAudit |
| TMUUSER | TMAUUSER | Userid |
| TMSDATE | TMSDATE | TmsReadCatalogDate |
| TMSLIB | TMSLIB | TmsLibraryIdentifier |
| TMABTCH | TMVABTCH | BatchUpdateIdNumber |
| TMACODE | TMVACODE | AuditCodeOfRecord |
| TMVACPU | TMVACPU | Cpuid |
| TMADATE | TMVADATE | DateOfLastAudit |
| TMAFLG1 | TMVAFLG1 | AuditFlag |
| TMAHOOK | TMVAHOOK | IdNumberOfLastHook |
| TMATIME | TMVATIME | TimeOfLastAudit |
| TMAUSER | TMVAUSER | Userid |
| TRERRC | TRERRC | TemporaryReadErrorClean |
| TRERRI | TRERRI | TemporaryReadErrorInit |
| TRTCH | TRTCH | Trtch |
| TTIME | TTIME | Ttime |
| TWERRC | TWERRC | TemporaryWriteErrorClean |
| TWERRI | TWERRI | TemporaryWriteErrorInit |
| UPD | UPD | TmcRecordUpdatedByUser? |
| USECLN | USECLN | UsecountAtLastCleaning |
| VALTREQ | VAULTREQ | VaultSpecificRequest? |
| VENDOR | VENDOR | TapeVendorName |
| VOLACTV | VOLACTV | ActualVolserInUse? |
| VOLPERC | VOLPERC | PhysicalSpaceOnVolInUsePct |
| VOLSEQ | VOLSEQ | VolumeSequenceNumber |
| VOLSER | VOLSER | VolumeSerialNumber |
| ZDATE | ZDATE | DateObservationCreated |
Note: Differences between MXG and ITRM column names are highlighted in yellow
Top of PageComputed Columns
| ITRM Column Name | Description | Expression |
|---|---|---|
| DATETIMEFIFTEENMIN | DatetimeFifteenMinute | Formula:DatetimeFifteenMinute |
| DATETIMEFIVEMIN | DatetimeFiveMinute | Formula:DatetimeFiveMinute |
| DATETIMEONEMIN | DatetimeOneMinute | Formula:DatetimeOneMinute |
| DATETIMETENMIN | DatetimeTenMinute | Formula:DatetimeTenMinute |
| DATETIMETHIRTYMIN | DatetimeThirtyMinute | Formula:DatetimeThirtyMinute |
| DATETIMETWENTYMIN | DatetimeTwentyMinute | Formula:DatetimeTwentyMinute |
| DAYDATE | DayDate | Formula:DayDate |
| DAYOFMONTH | DayOfMonth | Formula:DayOfMonth |
| DAYOFWEEK | DayOfWeek | Formula:DayOfWeek |
| HOUR | Hour | Formula:Hour |
| MONTHDATE | MonthDate | Formula:MonthDate |
| SHIFT | Shift | Formula:Shift |
| TIME | Time | Formula:Time |
| WEEKDATE | WeekDate | Formula:WeekDate |
| YEARDATE | YearDate | Formula:YearDate |
v3.3_1 28AUG2013