GMDELIV

Grant Sponsor Deliverables

The Sponsor Deliverables file stores information about different reports, information or other deliverables that need to be sent to an award's sponsor beforet the award can be closed.
UPDATED BY
AC110 AC300 AC10.1 AC112 AC12.1 AC50.1

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
GLV-ACTIVITY
Element: Activity
Alpha 15
Grant or project activity. Must exist in the GMAWARD file.
AC110
GLV-DELIV-CODE-DE
Element: Gm Code
Alpha 15
AC110
GLV-DATE
Element: Date
Numeric 8 (yyyymmdd)
The date the deliverable was sent.
AC110
GLV-USER-ID
Element: User Id2
Alpha 10 (Lower Case)
AC110
GLV-DUE-DATE
Element: Date
Numeric 8 (yyyymmdd)
This field displays the system date when this was created.
AC110
GLV-HR-COMPANY
Element: Company Hr
Numeric 4
AC110
GLV-EMPLOYEE
Element: Employee
Numeric 9
Contains the employee number. Each person employed by the company is assigned a unique number. The system uses the employee number to correlate all of the information related to that person.
AC110


GMDELIV FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
GLVSET1 ACTIVITY
DELIV-CODE-DE
AC10.1 AC110
AC112 AC12.1
AC300 AC50.1


GMDELIV FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME
RELATED FILE INTEGRITY RULES / FIELD MATCH
Acactivity ACACTIVITY Required
GLV-ACTIVITY->ACV-ACTIVITY
Employee EMPLOYEE Required
GLV-HR-COMPANY->EMP-COMPANY
GLV-EMPLOYEE->EMP-EMPLOYEE
Prsystem Comp PRSYSTEM Required
GLV-HR-COMPANY->PRS-COMPANY
Spaces->PRS-PROCESS-LEVEL


File created: Thu Jun 09 02:15:38 2016

Home
Contact Us



All trademarks and registered trademarks are the property of their respective owners.