GM_AU_PROPOSAL (SQL Table)	Index Back
Audit Record for Proposal This record automatically captures audit information for changes made to GM_PROPOSAL.

GM_AU_PROPOSAL

(SQL Table)

Audit Record for Proposal

This record automatically captures audit information for changes made to GM_PROPOSAL.

Audit Record Of GM_PROPOSAL

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 AUDIT_OPRID Character(30) VARCHAR2(30) NOT NULL The OPRID of the user who made the changes audited on an audit record.

2 AUDIT_STAMP DateTime(26) TIMESTAMP Date and Time Stamp

3 AUDIT_ACTN Character(1) VARCHAR2(1) NOT NULL Audit Action Code for Application Messages. This tells the subscriber whether the row has been added, changed, or deleted.
A=Add
C=Change Old (PPR Only)
D=Delete
K=Change - Old Values
N=Change - New Values
O=Change - Original Values

4 AUDIT_RECNAME Character(15) VARCHAR2(15) NOT NULL Name of the record definition audited. AUDIT_RECNAME is used in User-Defined Audit Record Definitions.

5 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

6 PROPOSAL_ID Character(25) VARCHAR2(25) NOT NULL Proposal ID

7 VERSION_ID Character(7) VARCHAR2(7) NOT NULL Version ID

8 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

9 NAME Character(50) VARCHAR2(50) NOT NULL Name

10 TITLE56 Character(56) VARCHAR2(56) NOT NULL TITLE56

11 CUST_ID Character(15) VARCHAR2(15) NOT NULL Uniquely identifies an organizational entity that purchases goods or services from the enterprise. Represents the sold-to customer which is the customer organization that places orders. The CUST_ID may or may not be the same as the identifiers for the bill-to and ship-to locations.

12 BEGIN_DT Date(10) DATE Begin Date

13 END_DT Date(10) DATE End Date

14 PROPOSAL_TYPE Character(3) VARCHAR2(3) NOT NULL PROPOSAL_TYPE
AMD=Amendment
CNT=Continuation
CON=Competing Continuation
INT=Internal
MOD=Modification
NEW=New
NOC=No-Cost Extension
NON=Non-Competing Continuation
NRS=NRSA
PRE=Pre-Proposal
RCA=Research Career Award
REN=Renewal
RES=Resubmission
REV=Revision
SB1=SBIR I
SB2=SBIR II
ST1=STTR I
ST2=STTR II
SUP=Supplemental

15 PROPOSAL_STATUS_GR Character(4) VARCHAR2(4) NOT NULL PROPOSAL_STATUS_GR
ACP=Accepted Award
APR=Institution Approved
AWD=Awarded
AWP=Award Pending
DEC=Declined by Sponsor
DIS=Discontinued
DRF=Draft
NOT=Not Funded
PEF=Pending Funding
PEN=Pending Approval
REF=Refused by Institution
REJ=Rejected
SUBM=Submitted
WIT=Withdrawn

16 SUBMIT_DTTM DateTime(26) TIMESTAMP Report Submitted On - DateTime

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	AUDIT_OPRID	Character(30)	VARCHAR2(30) NOT NULL	The OPRID of the user who made the changes audited on an audit record.
2	AUDIT_STAMP	DateTime(26)	TIMESTAMP	Date and Time Stamp
3	AUDIT_ACTN	Character(1)	VARCHAR2(1) NOT NULL	Audit Action Code for Application Messages. This tells the subscriber whether the row has been added, changed, or deleted. A=Add C=Change Old (PPR Only) D=Delete K=Change - Old Values N=Change - New Values O=Change - Original Values
4	AUDIT_RECNAME	Character(15)	VARCHAR2(15) NOT NULL	Name of the record definition audited. AUDIT_RECNAME is used in User-Defined Audit Record Definitions.
5	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
6	PROPOSAL_ID	Character(25)	VARCHAR2(25) NOT NULL	Proposal ID
7	VERSION_ID	Character(7)	VARCHAR2(7) NOT NULL	Version ID
8	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
9	NAME	Character(50)	VARCHAR2(50) NOT NULL	Name
10	TITLE56	Character(56)	VARCHAR2(56) NOT NULL	TITLE56
11	CUST_ID	Character(15)	VARCHAR2(15) NOT NULL	Uniquely identifies an organizational entity that purchases goods or services from the enterprise. Represents the sold-to customer which is the customer organization that places orders. The CUST_ID may or may not be the same as the identifiers for the bill-to and ship-to locations.
12	BEGIN_DT	Date(10)	DATE	Begin Date
13	END_DT	Date(10)	DATE	End Date
14	PROPOSAL_TYPE	Character(3)	VARCHAR2(3) NOT NULL	PROPOSAL_TYPE AMD=Amendment CNT=Continuation CON=Competing Continuation INT=Internal MOD=Modification NEW=New NOC=No-Cost Extension NON=Non-Competing Continuation NRS=NRSA PRE=Pre-Proposal RCA=Research Career Award REN=Renewal RES=Resubmission REV=Revision SB1=SBIR I SB2=SBIR II ST1=STTR I ST2=STTR II SUP=Supplemental
15	PROPOSAL_STATUS_GR	Character(4)	VARCHAR2(4) NOT NULL	PROPOSAL_STATUS_GR ACP=Accepted Award APR=Institution Approved AWD=Awarded AWP=Award Pending DEC=Declined by Sponsor DIS=Discontinued DRF=Draft NOT=Not Funded PEF=Pending Funding PEN=Pending Approval REF=Refused by Institution REJ=Rejected SUBM=Submitted WIT=Withdrawn
16	SUBMIT_DTTM	DateTime(26)	TIMESTAMP	Report Submitted On - DateTime