1. Calculate Something

1.1 Description (Functional Scope)

Calculate an estimate of the ...tables. 

1.2 Stakeholders & Actors

Producer    

1.3 Triggers

An executing workflow definition calls this task. 

1.4 Preconditions

The specified input datasets are available. 

1.5 Post-conditions & Guarantees

... totals have been calculated.

... distributions have been applied. 

1.6 Special Requirements

This step should not be run prior to .... Therefore, the requirement is that the IMS system does not allow the user to be able to calculate NI distributions prior t.....  

1.7 Input / Output summary

1.7.1 Files

None  

1.7.2 Database

Parameter Table

 

Name

Description

Year

The year for which to calculate ...

Quarter

The quarter for which to calculate the ...otals (e.g. 1, 2, 3, 4)

ResponseTable

Name of the SAS response table

LogTable

Name of the SAS log table

task_id

The id for the task within the current run.

stat_unit 

The statistical unit

NI_IPS_mig

Name of the view containing the ... data

NISRA_Rfv

Name of the view containing the ...data

NISRA_Resc

Name of the view containing the ... data

NISRA_agesex

Name of the view containing the...ata

Ukarea_hierarchy

Name of the view containing ... areas

NI_resc_hierarchy

Name of the view containing the ...e look-up data

NI_rfv_hierarchy

Name of the view containing the...t look-up data

Marconage__hierarchy

Name of the view containing the hierarchy for ... group aggregation

LTIM_sex_age_mapping

Name of the view containing the... variables

Cit_hierarchy          

Name of the view containing the ... aggregation.

Cob_hierarchy          

Name of the view containing the... aggregation.

Losind_hierarchy          

Name of the view containing the ...aggregation.

Marcon_hierarchy

Name of the view containing the...aggregation.

NI_age_hierarchy

Name of the view containing the... aggregation

 

Occ_hierarchy          

Name of the view containing the...aggregation.

Resc_hierarchy          

Name of the view containing the ...or next residence aggregation.

Rfv_hierarchy          

Name of the view containing the ...aggregation.

Sex_age_marcon_mapping

Name of the view containing th...con

NI_agesex _load_id

Load ID for NI b....

NI _cit_load_id

Load ID fo...

NI _cob _load_id

Load ID for NI by ...

NI _losind _load_id

Load ID for N...

NI _marcon _load_id

Load ID for N...

NI _occ _load_id

Load ID for NI...

NI _resc _load_id

Load ID for...

NI _rfv _load_id

Load I...

loadcolumn

Name of table i...

loaddefinition

Name of table i....

ud_variable_values_load_ims

 

Name of tabl...e written

 

 

Please note that layouts of input and output files are detailed below. Please refer to this key document <link> to determine the format of the variables in the input and output files

Input Data

 

Name

Description

Variables

NI_IPS_Mig

Calibrated IPS data for the last xxxxxxxxxxx in ‘last_quarter’

 

Selection criteria to be applied

where xxxx AND

LOSINDxxx) AND

UKxxxx02

 

RecordKey

Age

 

Year

Rfv 

Cit

Losind 

Cob

Marcon 

Occ

Dir 

Qtr

Sex 

Resc

Wtfrsign 

 

Schedno 

 

NIweight1

 

NIweight2

NIweight3

NIweight4

 

NISRA_rfv

 

Reason ...

(Aggregate)

Year

Qtr

Rfv

pCount

NISRA_resc

Country of...

(Aggregate)

Year

Qtr

resc

pCount

NISRA_agesex

 

Age group ...a).

 

Note: The age...

 

(Aggregate)

 

Year

Qtr

Dir

Sex

Age

pCount