Data Sources and Master Files
|
Topics: |
This appendix provides a description of the data sources used in the reporting language examples.
The file that describes a data source is called a Master File. This file provides the names and formats of each field in the data source.
You can display the structure of a data source by issuing the following command:
CHECK FILE filename PICTURE
EMPLOYEE Data Source
EMPLOYEE contains sample data about company employees.
The following is the EMPLOYEE Master File for your reference.
FILENAME=EMPLOYEE, SUFFIX=FOC SEGNAME=EMPINFO, SEGTYPE=S1 FIELDNAME=EMP_ID, ALIAS=EID, FORMAT=A9, $ FIELDNAME=LAST_NAME, ALIAS=LN, FORMAT=A15, $ FIELDNAME=FIRST_NAME, ALIAS=FN, FORMAT=A10, $ FIELDNAME=HIRE_DATE, ALIAS=HDT, FORMAT=I6YMD, $ FIELDNAME=DEPARTMENT, ALIAS=DPT, FORMAT=A10, $ FIELDNAME=CURR_SAL, ALIAS=CSAL, FORMAT=D12.2M, $ FIELDNAME=CURR_JOBCODE, ALIAS=CJC, FORMAT=A3, $ FIELDNAME=ED_HRS, ALIAS=OJT, FORMAT=F6.2, $ SEGNAME=FUNDTRAN, SEGTYPE=U, PARENT=EMPINFO FIELDNAME=BANK_NAME, ALIAS=BN, FORMAT=A20, $ FIELDNAME=BANK_CODE, ALIAS=BC, FORMAT=I6S, $ FIELDNAME=BANK_ACCT, ALIAS=BA, FORMAT=I9S, $ FIELDNAME=EFFECT_DATE, ALIAS=EDATE, FORMAT=I6YMD, $ SEGNAME=PAYINFO, SEGTYPE=SH1, PARENT=EMPINFO FIELDNAME=DAT_INC, ALIAS=DI, FORMAT=I6YMD, $ FIELDNAME=PCT_INC, ALIAS=PI, FORMAT=F6.2, $ FIELDNAME=SALARY, ALIAS=SAL, FORMAT=D12.2M, $ FIELDNAME=JOBCODE, ALIAS=JBC, FORMAT=A3, $ SEGNAME=ADDRESS, SEGTYPE=S1, PARENT=EMPINFO FIELDNAME=TYPE, ALIAS=AT, FORMAT=A4, $ FIELDNAME=ADDRESS_LN1, ALIAS=LN1, FORMAT=A20, $ FIELDNAME=ADDRESS_LN2, ALIAS=LN2, FORMAT=A20, $ FIELDNAME=ADDRESS_LN3, ALIAS=LN3, FORMAT=A20, $ FIELDNAME=ACCTNUMBER, ALIAS=ANO, FORMAT=I9L, $ SEGNAME=SALINFO, SEGTYPE=SH1, PARENT=EMPINFO FIELDNAME=PAY_DATE, ALIAS=PD, FORMAT=I6YMD, $ FIELDNAME=GROSS, ALIAS=MO_PAY, FORMAT=D12.2M, $ SEGNAME=DEDUCT, SEGTYPE=S1, PARENT=SALINFO FIELDNAME=DED_CODE, ALIAS=DC, FORMAT=A4, $ FIELDNAME=DED_AMT, ALIAS=DA, FORMAT=D12.2M, $ SEGNAME=JOBSEG, SEGTYPE=KU, PARENT=PAYINFO, CRFILE=JOBFILE, CRKEY=JOBCODE,$ SEGNAME=SECSEG, SEGTYPE=KLU, PARENT=JOBSEG, CRFILE=JOBFILE, $ SEGNAME=SKILLSEG, SEGTYPE=KL, PARENT=JOBSEG, CRFILE=JOBFILE, $ SEGNAME=ATTNDSEG, SEGTYPE=KM, PARENT=EMPINFO, CRFILE=EDUCFILE, CRKEY=EMP_ID,$ SEGNAME=COURSEG, SEGTYPE=KLU, PARENT=ATTNDSEG, CRFILE=EDUCFILE,$
The following diagram illustrates the structure of the EMPLOYEE data source.
JOBFILE Data Source
JOBFILE contains sample data about company job positions.
The following is the JOBFILE Master File for your reference.
FILENAME=JOBFILE, SUFFIX=FOC SEGNAME=JOBSEG, SEGTYPE=S1 FIELDNAME=JOBCODE, ALIAS=JC, FORMAT=A3, INDEX=I,$ FIELDNAME=JOB_DESC, ALIAS=JD, FORMAT=A25 ,$ SEGNAME=SKILLSEG, SEGTYPE=S1, PARENT=JOBSEG FIELDNAME=SKILLS, ALIAS=, FORMAT=A4 ,$ FIELDNAME=SKILL_DESC, ALIAS=SD, FORMAT=A30 ,$ SEGNAME=SECSEG, SEGTYPE=U, PARENT=JOBSEG FIELDNAME=SEC_CLEAR, ALIAS=SC, FORMAT=A6 ,$
The following diagram illustrates the structure of the JOBFILE data source.
JOBSEG
01 S1
**************
*JOBCODE **I
*JOB_DESC **
* **
* **
* **
***************
**************
I
+-----------------+
I I
I SECSEG I SKILLSEG
02 I U 03 I S1
************** *************
*SEC_CLEAR * *SKILLS **
* * *SKILL_DESC **
* * * **
* * * **
* * * **
************** **************
*************EDUCFILE Data Source
EDUCFILE contains sample data about company in-house courses.
The following is the EDUCFILE Master File for your reference.
FILENAME=EDUCFILE, SUFFIX=FOC SEGNAME=COURSEG, SEGTYPE=S1 FIELDNAME=COURSE_CODE, ALIAS=CC, FORMAT=A6, $ FIELDNAME=COURSE_NAME, ALIAS=CD, FORMAT=A30, $ SEGNAME=ATTNDSEG, SEGTYPE=SH2, PARENT=COURSEG FIELDNAME=DATE_ATTEND, ALIAS=DA, FORMAT=I6YMD, $ FIELDNAME=EMP_ID, ALIAS=EID, FORMAT=A9, INDEX=I, $
The following diagram illustrates the structure of the EDUCFILE data source.
COURSEG
01 S1
**************
*COURSE_CODE **
*COURSE_NAME **
* **
* **
* **
***************
**************
I
I
I
I ATTNDSEG
02 I SH2
**************
*DATE_ATTEND **
*EMP_ID **I
* **
* **
* **
***************
**************EMPDATA Data Source
EMPDATA contains sample data about company employees.
The following is the EMPDATA Master File for your reference.
FILENAME=EMPDATA, SUFFIX=FOC SEGNAME=EMPDATA, SEGTYPE=S1 FIELDNAME=PIN, ALIAS=ID, FORMAT=A9, INDEX=I, $ FIELDNAME=LASTNAME, ALIAS=LN, FORMAT=A15, $ FIELDNAME=FIRSTNAME, ALIAS=FN, FORMAT=A10, $ FIELDNAME=MIDINITIAL, ALIAS=MI, FORMAT=A1, $ FIELDNAME=DIV, ALIAS=CDIV, FORMAT=A4, $ FIELDNAME=DEPT, ALIAS=CDEPT, FORMAT=A20, $ FIELDNAME=JOBCLASS, ALIAS=CJCLAS, FORMAT=A8, $ FIELDNAME=TITLE, ALIAS=CFUNC, FORMAT=A20, $ FIELDNAME=SALARY, ALIAS=CSAL, FORMAT=D12.2M, $ FIELDNAME=HIREDATE, ALIAS=HDAT, FORMAT=YMD, $ $ DEFINE AREA/A13=DECODE DIV (NE 'NORTH EASTERN' SE 'SOUTH EASTERN' CE 'CENTRAL' WE 'WESTERN' CORP 'CORPORATE' ELSE 'INVALID AREA');$
The following diagram illustrates the structure of the EMPDATA data source.
EMPDATA 01 S1 ************** *PIN **I *LASTNAME ** *FIRSTNAME ** *MIDINITIAL ** * ** *************** **************
FINANCE Data Source
FINANCE contains sample financial data for balance sheets. Aliases do not exist for the fields in this Master File, and the commas (,) act as placeholders.
The following is the FINANCE Master File for your reference.
FILENAME=FINANCE, SUFFIX=FOC,$ SEGNAME=TOP, SEGTYPE=S2,$ FIELDNAME=YEAR , , FORMAT=A4, $ FIELDNAME=ACCOUNT, , FORMAT=A4, $ FIELDNAME=AMOUNT , , FORMAT=D12C,$
The following diagram illustrates the structure of the FINANCE data source.
TOP 01 S2 ************** *YEAR ** *ACCOUNT ** *AMOUNT ** * ** * ** *************** **************
SALHIST Master File
SALHIST contains information about employee salary history.
The following is the SALHIST Master File for your reference.
FILENAME=SALHIST, SUFFIX=FOC SEGNAME=SLHISTRY, SEGTYPE=SH2 FIELDNAME=PIN, ALIAS=ID, FORMAT=A9, INDEX=I, $ FIELDNAME=EFFECTDATE, ALIAS=EDAT, FORMAT=YMD, $ FIELDNAME=OLDSALARY, ALIAS=OSAL, FORMAT=D12.2, $
The following diagram illustrates the structure of the SALHIST data source.
SLHISTRY 01 SH2 ************** *PIN **I *EFFECTDATE ** *OLDSALARY ** * ** * ** *************** **************
| WebFOCUS | |
|
Feedback |