GMDELIV

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
AC10.1

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
GLV-ACTIVITY
Element: Activity		Alpha 15
Grant or project activity. Must exist in the GMAWARD file.
GLV-DELIV-CODE-DE
Element: Gm Code		Alpha 15
GLV-DATE
Element: Date		Numeric 8 (yyyymmdd)
The date the deliverable was sent.
GLV-USER-ID
Element: User Id2		Alpha 10 (Lower Case)
GLV-DUE-DATE
Element: Date		Numeric 8 (yyyymmdd)
This field displays the system date when this was created.
GLV-HR-COMPANY
Element: Company Hr		Numeric 4
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.


GMDELIV FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
GLVSET1 ACTIVITY
DELIV-CODE-DE
AC10.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: Wed Jun 08 20:49:00 2016

Home
Contact Us



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