GA Security Report

Entity* 

ID of the entity/employer.  The entity should be a valid entry as defined in BusinessPLUS.  Once saved, the value cannot be changed. 

Employer Name* 

Name of the employer for whom the entity is defined. 

Employer Address* 

First line of the employer’s address.  

Employer Address (2) 

Second line of the employer’s address.  

Employer City* 

City in which the employer is located. 

Employer State* 

State in which the employer is located. 

Click for the list of states. 

Employer Zip Code* 

Numeric zip code of the employer’s location.  This field accepts only five numeric characters and does not accept if all the five characters are zeroes. 

Employer Zip Code Extension 

Numeric zip code extension of the employer’s location.  This field accepts only numeric characters of 4 digits or less. 

School System Code* 

A number that identifies an active school system code. This field accepts  only numeric characters. 

GL Location Part* 

This contains the part 01 to part 08 values. These are used to select the corresponding ‘Group Part’ value from GL Key Master Table. 

Eg: If ‘part03’ is selected, value stored in ‘glk_grp_part03’ belonging to ‘glk_key_mstr’ table will be used for calculating the assignment school code. 

Long Term Sub Field 

It is the long term substitute field that is present in the empmstr table  in the IFAS. 

Either select ‘type’ or ‘bargunit’. 

Long Term Sub Values 

It is a single value or a list of comma separated values that denote long term substitute. 

Eg.: FT, PLCE,CNTC,CNST etc 

Rehired Retiree Field 

It is the rehired retiree field that is present in the empmstr table  in the IFAS. 

Either select ‘type’ or ‘bargunit’. 

Rehired Retiree Value 

It is a single value or a list of comma separated values that denote rehired retiree. 

Eg.: ADMIN,BMS,POA,BMS3 etc 

Name* 

Name of the report instance as defined by the user. 

Eg.: GA Security 2009 

Fiscal Year*  

4-digit Fiscal Year for which the extraction is required.  

Eg.: 2009 

Start Date* 

The start date from where the extraction should begin.  

Eg.: 1/1/2009 

End Date* 

The end date at which the extraction should end. 

Eg.: 7/19/2009 

Report Instance* 

Click for the list of report instances.  Select the desired report instance.   

Notes  

Enter a note related to report instance or load that is to be performed. 

Entity ID* 

Click to select a specific entity for which the load will be performed. Select ‘ALL’ to extract records of all entities. 

Employee ID(s) 

If specific IDs are to be refreshed or reported on, enter in this line, separated by commas. 

Purge Existing Data 

If all the existing data for the selected ‘Report Instance’ in the maintenance table needs to be deleted, this checkbox should be checked.  

This action will also remove new (recent) maintenance records added previously using the maintenance screen for the ‘Report Instance’.  

 Load (Button)

Click to load maintenance records into maintenance table. 

Report Instance Details 

Details of the selected Report Instance. 

Last Load for the Selected Report Instance 

The date (Last Load) and user (Created By) who performed the last load and any notes entered for the selected ‘Report Instance’.  If the report is loaded for the first time for the selected ‘Report Instance’, this information is blank. 

“Report Profile information for ‘Long Term Substitute’ not configured for following entity – ROOT” 

Set Report Profile configurations for ‘ROOT’entity. 

“Report Profile information for ‘Rehired Retiree’ not configured for following entity – ROOT” 

Set Report Profile configurations for ‘ROOT’ entity. 

Report Instance* 

Click for the list of report instances.  Choose the report instance which is to be submitted. 

Notes  

Any notes applicable to the submission job. 

Filename* 

System generated or user defined file name for the submission file.   

The filename should always end with the ‘.txt’ extension.  The filename cannot contain these characters ‘\:/*?”<>|’  

NOTE:  The path where the file is saved is already configured in the application and should not be entered here.   

In some reports, the report name is auto-generated and hence the text filename cannot be changes for such reports.  

Example: 2011_Quarter2.txt 

Entity ID* 

Click for the list of entities.  If the maintenance records for all the entities are to be submitted, then ‘ALL’ should be selected. 

Report Instance Details 

Details for the selected ‘Report Instance’. 

Last Submission for the Selected Report Instance 

The date (Last Submission) and user (Created By) who performed the last submission and the note that was entered for submitting the selected ‘Report Instance’. 

 Double Arrow (Button)

Regenerate the Filename. 

 Generate Report (Button)

Create report file with data from maintenance table. 

 View Report (Button)

View the submission file report. 

1* 

1-4 

N 

4 

Fiscal Year 

rr_run_def_mstr 

fiscal_yr 

Fiscal Year 

This is taken as user input from Report Instance screen 

2* 

5-7 

A 

3 

System Code 

rr_site_profile 

school_system_code 

School System code 

This is taken as user input from Site Profile screen 

3* 

8-16 

A 

9 

Social Security Number 

hr_empmstr 

ssn 

Employee’s Social Security Number 

4* 

17-24 

D 

8 

Birth Date 

hr_empmstr 

bdt 

Employee Birth Date 

YYYYMMDD 

5 

25-25 

A 

1 

Employee 

Type 

hr_empmstr 

Long Term Sub Field or Rehired Retiree Field ; based on  values configured from Report Profile screen 

Must be one among the following values: 

“L”= Long-Term Substitute 

“B” = Rehired Retiree 

Blank/null = regular employee. 

Based on Long Term Sub Field and Long Term Sub Values or Rehired Retiree Field and Rehired Retiree Values of Report Profile screen. 

If Rehired Retiree values matches the hr_empmstr.Rehired Retiree Field, then EmpType =’B’ ; 

Else 

If Long Term Sub Values matches the hr_empmstr.Long Term Sub Field,then EmpType=’L’; 

If Employee belogs to both of the above categories, then rehired retiree takes precedence over long term substitute 

If employee does not belong to any of above category, employee type is defaulted to blank in which case it represents active employee 

6* 

26-55 

A 

30 

Last Name 

hr_empmstr 

lname 

Employee’s last name 

7* 

56-85 

A 

30 

First Name 

hr_empmstr 

fname 

Employee’s first name 

8 

86-86 

A 

1 

Middle Initial 

hr_empmstr 

mname 

Employee’s middle initial 

First character of mname from hr_empmstr 

9 

87-87 

A 

1 

Termination Code 

hr_empmstr 

termcode 

TERMINATION CODE must be one of the following valid values: 

"1" = Retirement 

   "2" = Death 

   "3" = Family 

   "4" = Advanced Study 

   "5" = Nonrenewal of Contract 

  "6" = Acceptance of Position in other Georgia School System 

"7" = Reduction in Force 

"8" = Failure to Meet Certification Requirements 

"9" = Resignation 

"0" = Active employees only. 

If TERMINATION CODE is valid, then there must be a TERMINATION DATE. 

Second character of termcode from hr_empmstr 

10 

88-95 

D 

8 

Termination Date 

hr_empmstr 

enddt 

Employee Termination Date 

YYYYMMDD 

11* 

96-99 

A 

4 

Assignment School Code 

glk_key_mstr 

GL Location Part selected from the site profile screen 

Assignment School Code 

First 4 characters of the value corresponding to selected GL Location Part (configured from Site Profile screen) of glk_key_mstr 

12* 

100-102 

A 

3 

Assignment Job Code 

hr_pcntble 

CBEDS 

Assignment Job Code  

First 3 characters from CBEDS of hr_pcntble