DTR for USPS

1
DTR for USPS

• OEDSA Fall 2004

2
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

3
Primary Domains

• EMPLOYEE
• BIOSCN/DEMSCN data
• JOB_POSITION
• JOBSCN/POSSCN data
• BENEFIT_BAL
• BENSCN data

4
Primary Domains

• ABSENCES
• ATDSCN data
• DEDUCTIONS
• DEDSCN data
• PAYROLL_ACCOUNTS
• PAYSCN data

5
Primary Domains

• History domains
• CHECK_HISTORY
• PAY_AMOUNTS_HISTORY
• ACCOUNT_HISTORY
• DEDUCTION_HISTORY

6
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

7
Primary Views

• ALL_JOBS
• Limited BIOSCN/DEMSCN data
• JOBSCN/POSSCN data
• HISTORY_CHECKS
• CHECK_HISTORY data
• PAY_AMOUNTS_HISTORY data

8
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

9
Common Commands

• SET DICTIONARY
• Sets your DTR dictionary to appropriate software
  package
• SET DICTIONARY OECNCDD_PAY
• READY
• Prepares a domain or view for access
• READY JOB_POSITION READ
• READY JOB_POSITION SHARED READ
• READY JOB_POSITION MODIFY
• READY JOB_POSITION WRITE
• READY JOB_POSITION AS JP SHARED READ

10
Common Commands

• 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
• Example 8,9,13
• SHOW CURRENT
• Show current domain and collection

13
Common Commands

• SELECT
• Selects a specific record in the collection
• SELECT
• SELECT LAST
• 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
• SORTED BY LAST_NAME,FIRST_NAME
• SORTED BY DDED,LAST_NAME,FIRST_NAME
• Example 4,5,6,7,10,11,14

15
Common Commands

• SUM
• Provides a total
• SUM YTD_GROSS BY SSN
• DECLARE
• Used to create variables
• Example 4,5,6,12,14

16
Common Commands

• CROSS
• Allows two different domains to be accessed
  simultaneously
• Must be done on a primary key
• Example 5,7,10,11

17
Common Commands

• PRINT
• Prints all the records in current collection
  horizontally
• Can specify certain fields
• Example 4,5,6,7,10,14
• PRINT USING
• Provides edit capabilities on fields
• Example 4

18
Common Commands

• COL nn
• Prints data in a specific column
• Example 4,7,14
• REPORT
• Creates output report with a FIND or FOR
  statement in one step
• Example 10,11,14

19
Command Commands

• SET
• COLUMNS_PAGE 132
• Sets report to 132 character width
• REPORT_NAME
• Report heading
• Example 4
• LINES_PAGE ??
• Sets the number of lines per page
• Example 10

20
Common Commands

• AT BOTTOM OF fieldname
• Tallies a total by fieldname
• AT BOTTOM OF SSN
• AT BOTTOM OF DED
• Example 6,11
• AT TOP OF PAGE
• Prints headings
• Example 7

21
Common Commands

• AT BOTTOM OF REPORT
• Provides a trailer record at the end of report
• Commonly used with TOTAL fieldname
• Example 14
• MODIFY
• Allows modification of records in current
  collection
• Example 8,9

22
Common Commands

• STORE
• Allows records to be written to files
• Must properly initialize all fields
• ERASE
• Deletes all records in current collection
• Cant be undone without a restore of file

23
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

24
Common Usage

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