|
|
GMDELIV FILE
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.
REFERENCED BY
AC10.1 AC112 AC12.1 AC50.1
UPDATED BY
AC110 AC300 AC310
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
GLV-ACTIVITY Alpha 15 AC110
Element: Activity Grant or project activity. Must exist
in the GMAWARD file.
GLV-DELIV-CODE-DE Alpha 15 AC110
Element: Gm Code
GLV-DATE Numeric 8 (yyyymmdd) AC110
Element: Date The date the deliverable was sent.
GLV-USER-ID Alpha 10 (Lower Case) AC110
Element: User Id2
GLV-DUE-DATE Numeric 8 (yyyymmdd) AC110
Element: Date This field displays the system date
when this was created.
GLV-HR-COMPANY Numeric 4 AC110
Element: Company Hr
GLV-EMPLOYEE Numeric 9 AC110
Element: Employee 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 AC10.1 AC110
DELIV-CODE-DE AC112 AC12.1
AC300 AC310
AC50.1
GMDELIV FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME 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
|
