|
|
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
AC112 AC12.1 AC50.1
UPDATED BY
AC110 AC300 AC310 AC10.1
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 Contains the user ID of the person who
last changed this record.
GLV-DUE-DATE Numeric 8 (yyyymmdd) AC110
Element: Date The transaction due date.
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
Gmcodes De GMCODES Required
"DE" -> GMF-TYPE
GLV-DELIV-CODE-DE -> GMF-CODE
Prsystem Comp PRSYSTEM Required
GLV-HR-COMPANY -> PRS-COMPANY
Spaces -> PRS-PROCESS-LEVEL
|
