DTR for USPS ITC Intermediate Training 1 Domains

DTR for USPS ITC Intermediate Training 1

Domains • A domain in DTR is a definition for a given data file – Includes every defined field – May include declared fields • Reformatted dates • Names • Descriptions 2

Primary Domains • EMPLOYEE – BIOSCN/DEMSCN data • JOB_POSITION – JOBSCN/POSSCN data • BENEFIT_BAL – BENSCN data 3

Primary Domains • ABSENCES – ATDSCN data • DEDUCTIONS – DEDSCN data • PAYROLL_ACCOUNTS – PAYSCN data 4

Primary Domains • History domains – CHECK_HISTORY – PAY_AMOUNTS_HISTORY – ACCOUNT_HISTORY – DEDUCTION_HISTORY 5

Views • A view in DTR is a combination of one or more domains based on primary file key such as employee ID – Read only access to files 6

Primary Views • ALL_JOBS – Limited BIOSCN/DEMSCN data – JOBSCN/POSSCN data • HISTORY_CHECKS – CHECK_HISTORY data – PAY_AMOUNTS_HISTORY data 7

Primary Views • EMP_WITH_JOB_LIST – BIOSCN/DEMSCN data – JOBSCN/POSSCN data – BENSCN data • PAYACT_JOB_INFO – – Limited BIOSCN data JOBSCN/POSSCN data PAYSCN data BENSCN data 8

Common Commands • SET DICTIONARY – Sets your DTR dictionary to appropriate software package • SET DICTIONARY OECN$CDD_USPS 42 • READY – Prepares a domain or view for access – READY JOB_POSITION READ • Display Only – READY JOB_POSITION SHARED READ • SHARED: allows other users to also access the file • READ: allows you to view the data only 9

Common Commands – READY JOB_POSITION MODIFY ‾ Modify Only – READY JOB_POSITION WRITE ‾ Allows you to modify or add/delete data – READY JOB_POSITION AS A SHARED READ 10

Common Commands • SHOW DOMAINS - Lists available domains • SHOW FIELDS - Lists fields that are used in domain or view that was used in the READY command 11

Common Commands • FIND – Allows retrieval or selection of data, called a collection • • Used after READY FIND A IN EMPLOYEES WITH STATE = “OH” String multiple values for same field with a “, ” Use AND to select on multiple fields 12

Common Commands • FOR – Allows retrieval or selection of data, called a collection • SHOW CURRENT – Show current domain and collection 13

Common Commands • SELECT – Selects a specific record in the collection • SELECT FIRST; LIST • SELECT LAST; LIST • LIST – Lists all the records in current collection vertically – Can specify certain fields 14

Common Commands • SORTED – Allows a sort on any field in collection • SORTED BY LAST_NAME, FIRST_NAME • SORTED BY DDED, LAST_NAME, FIRST_NAME Command-FOR CURRENT SORT TRUE_SSN Command-FOR CURRENT LIST 15

Common Commands • SUM – Provides a total • SUM YTD_GROSS BY SSN 16

Common Commands • PRINT – Prints all the records in current collection horizontally. Specify name for report. • Can specify certain fields 17

Common Commands • ERASE – Deletes all records in current collection – Can’t be ‘undone’ without a restore of file – Always have a backup of districts files before deleting records – Try first in a copy of the districts files, to get desired affect 18

Find-Common Commands • • • EQUAL: equal, eq, = NOT EQUAL: no_equal, not=, ne GREATER THAN: gt, greater_than, > LESS THAN: lt, less_than, < BETWEEN: between , BT CONTAINING: containing, cont NOT CONTAINING: not containing, not cont STARTS WITH VALUE: starting with Can also use AND/OR for more complex expressions 19

Examples of FIND Conditions • • • EQUAL: FIND A WITH TYPE=“AT” NOT EQUAL: FIND A WITH TYPE NE”AT” GREATER THAN: FIND A WITH PAY_CHECK_NO GT” 501574” LESS THAN: FIND A WITH PAY_CHECK_NO LT” 501574” BETWEEN: FIND A IN ABSENCES WITH DISP_DATE BT “YYYMMDD” AND “YYYYMMDD” – FIND B IN A WITH CAT=“SI” AND TYPE=“AB” • CONTAINING: FIND A WITH CAL_START CONT”YYYMMDD” • STARTS WITH: FIND A WITH CK_NO STARTING WITH” 501587” • AND: FIND A WITH CAT=“SI” AND TYPE=“AB” 20

Common Usage • General Reports • Data for Spreadsheets – Can use standard text file created using the PRINT fieldname, fieldname ON filename. TXT for import into a spreadsheet • Change incorrect period begin/end dates on check history 21

Common Usage • Modify BRDDIS posting flag on account history • Modify STRS per pay reporting flag • Calculation of amounts • Change values in fields 22