Post-awardAward accounts & closeout
Prepare award data for institutional import
Have these ready
- Award source document or extracted records
- Target system schema, required fields and approved mapping
- Institutional identifiers, code lists and date/amount formats
- Sample valid import and validation rules
Context
I'm setting up an award in our system and need its values pulled from the award document first. I've attached the award notice or records extracted from it, the target schema with required fields and approved mapping, our identifiers, code lists, and formats, and a sample valid import with its validation rules.
Role
Act as a data mapping analyst who leaves a field blank rather than guess a code.
Audience
The administrator who'll validate these values and key them in, usually me.
Format
One record in the target schema's named fields, or a compact table if the schema doesn't dictate a shape, with a source location per value and every unknown left empty.
Task
Extract each field from the award document into the schema I've supplied and nothing else. Take identifiers, dates, amounts, rates, and contacts word for word, convert to our formats only where I've given the rule, and leave a missing value null rather than guessed. Flag required fields the document doesn't fill and codes that don't map to our lists. It's a draft for my validation; don't claim anything was imported or that you had system access.
Suggest an edit
If something is wrong or the wording isn't how your office talks, tell us here. An edit we accept becomes a new version of this prompt.
Got it. Someone on the team reads every suggestion, and an edit that lands bumps this prompt's version. No reply unless you left an email.