This topic provides the SPO data entry technician and Command Self Service role user with general information and links to step-by-step procedures to generate a Unit Roster.
The unit roster includes the following data elements. It can be generated in "CSV" format, which is compatible with MS Excel.
|Relationship to Parent Command (HRS, ISC, Own Unit)
|Department ID of the parent department
|Member's Employee ID number
|Member's Employee Record number
|Member Last Name
|Member's last name
|Member First Name
|Member's first name.
|Member's employee classification (e.g AD for Active Duty, SEL for SELRES)
|Member's assigned department ID
|Name of member's assigned department
|Member's assigned department ATU and OPFAC number
|Exp Loss Dt
|Member's expected loss date
|Exp AD Term Dt
|Member's active duty termination date
|Member's rotation date
|Member's date of birth
|AD Base Dt
|Member's active duty base date
|Date of Rank
|Member's date of rank
|Date member reported to current department
|Reserve member's anniversary date (AY)
|Member's security clearance level
|Reserve member's training rating (numeric code)
|Cost center for member's assigned position
|Sea Pay Prem Dt
|Date career sea pay premium started
|Member's BAH code and description
|RES Screen Dt
|Reserve member's ASQ completion date
|CUM Sea Time YY MM DD
|Years, Months and Days of cumulative sea time
|Member's marital status
M = Married
D = Divorce
S = Single
|Member's ethnic group
|Last Good Con Dt
|Date of member's last Coast Guard Good Conduct Award
|Member's assigned position number
|Posn Entry Dt
|Date member reported to current position
|Member's gender. M = Male, F = Female
|Position sensitivity code
|Position security clearance requirement
|Member's citizenship status
|Member's leave balance
|Code for obligated service.
Note: Numbered entries are for additional instances of the same type of obligation.
|Long Term Training
|Tuition Assistance 10
|Tuition Assistance 2
|Tuition Assistance 3
|Tuition Assistance 4
|Tuition Assistance 5
|Tuition Assistance 6
|Tuition Assistance 7
|Tuition Assistance 8
|Tuition Assistance 9
|Advance Ed. Post Grad School
|Critical Skill Reten Bonus
|Critical Skill Reten Bonus 2
|Flight School Obligated Serv
|Post 9/11 GI Bill
|Effective date of service obligation
|Duration of service obligation from the effective date.
|Regulatory region code.
|Active Duty NOAA
|PHS Positions Filled by Military or Civilian
|No Military Service
|Retired Coast Guard
*See known issues.
Direct Access Navigation
1. Portal Pagelet: N/A
2. Menu Path: Human Resources, then Human Resources Reports and finally CG Unit Roster Report.
Direct Access Procedures
When HRS or ISC relationship is used members attached to the SPO (HRS) or Base (ISC) will not appear in the results. Run the query again with the "Own Unit" relationship to see data on these members.
Frequently Asked Questions (FAQ)
Contact the Pay & Personnel Center, Procedures & Development Branch, via e-mail to PPC-PF-PD@uscg.mil, with comments or questions about the content of this topic or the linked procedural guides.