Calculate an estimate of the ...tables.
Producer
An executing workflow definition calls this task.
The specified input datasets are available.
... totals have been calculated.
... distributions have been applied.
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.....
None
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
|
|
||||||||||||||||||||
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 |