Appendix A: Web Report Extract File Layouts
National Student Loan Data System
Unusual Working Hours (SECWH1)
October19, 2008
1.0 NSLDS Unusual Working HoursExtract File Layout (SECWH1)
The Unusual Working Hours Report (SECWH1) providesED and the PDPA a list of the organization’s NSLDS online users who logged on the NSLDSFAP Web site at times specified in the request parameters. Intended to provide information on users who access NSLDS outside normal working hours, any time period from 00:00 to 23:59 in a 24 hour period (using the central time zone) can be designated. Sort options include User ID, Work Date, and Last Name/First Name.
This section contains extract file layouts that list the header, details, and trailer records for the extract version of the report. Each online extract request is used to generate one header record, one or more detail records, and one trailer record. Each record layout table contains the position, the data element name, description, field format, and length.
2.0 Unusual Working HoursReport Record Layouts
Header RecordLength = 120
Pos FR / Pos TO /Data Element /
Description / Field Format /
Lth
1 / 1 / Record Type / ‘0’–Represents Header / Char. / 1
2 / 35 / Header Title / Value ‘UNUSUAL WORKING HOURS REPORT’ / Char. / 34
36 / 41 / Report Id / Identifier of report. Value ‘SECWH1’ / Char. / 6
42 / 44 / Org Type / Type of organization on report / Char. / 3
45 / 52 / Org Code / Code for the organization which requested the report. / Char. / 8
53 / 60 / User ID / User ID specified in parameters, if any / Char. / 8
61 / 68 / Begin Date / Lower end of date range. / Date / 8
69 / 76 / End Date / Upper end of date range. / Date / 8
77 / 81 / Begin Time / Beginning of unusual hours. Format HH:MM / Time / 5
82 / 86 / End Time / Ending of unusual hours. Format HH:MM / Time / 5
87 / 103 / Filler / Attribute to complete record length. / Char. / 17
104 / 104 / Submittal Report Type / ‘R’ = Report
‘E’ = Extract data file / Char. / 1
105 / 112 / Submittal Date / Date which the report request is submitted. Format CCYYMMDD. / Date / 8
113 / 118 / Submittal Time / Time which the Loan Discharge Report request is submitted. Format HHMMSS. / Time / 6
119 / 120 / Filler / Attribute to complete record length. / Char. / 2
Detail RecordLength = 120
Pos FR / Pos TO /Data Element /
Description / Field Format /
Lth
1 / 1 / Record Type / ‘1’–Represents Detail / Char. / 1
2 / 9 / User ID / User ID of the user accessing the system during unusual working hours. / Char. / 8
10 / 17 / SAIG Mailbox / The SAIG mailbox (TG number) of the user. / Char. / 8
18 / 52 / Last Name / Online user’s last name / Char. / 35
53 / 64 / First Name / Online user’s first name / Char. / 12
65 / 72 / Date / Date when user worked unusual hours / Date / 8
73 / 76 / Start Time / Time when unusual hours began / Time / 4
77 / 80 / End Time / Time when unusual hours ended / Time / 4
81 / 120 / Filler / Attribute to complete record length. / Char. / 40
Trailer RecordLength = 120
Pos FR / Pos TO /Data Element /
Description / Field Format /
Lth
1 / 1 / Record Type / ‘9’–Represents Trailer Record / Char. / 1
2 / 10 / Record Count / Total count of records. / Num. / 9
11 / 120 / Filler / Attribute to complete record length. / Char. / 110
October 19, 2008NSLDS Unusual Working HoursReport Extract File Layout
1