GM_EC_CERT_COMM (SQL View)	Index Back
Proposal Certifications This record allows the user to certify proposal-specific certifications, and store the date certified, comments, and the professional who is making the certification. Multiple certifications can be made per a proposal on this panel. This record is stored in GR_01_03_0100.

GM_EC_CERT_COMM

(SQL View)

Proposal Certifications

This record allows the user to certify proposal-specific certifications, and store the date certified, comments, and the professional who is making the certification. Multiple certifications can be made per a proposal on this panel. This record is stored in GR_01_03_0100.

SELECT BUSINESS_UNIT, PROPOSAL_ID, VERSION_ID, SUB_PROP_NBR, CERT_CODE, COMMENTS FROM PS_GM_PROP_CERT

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
Prompt Table: SP_BU_PC_NONVW

2 PROPOSAL_ID Character(25) VARCHAR2(25) NOT NULL Proposal ID
Prompt Table: GM_PROP_ID_VW

3 VERSION_ID Character(7) VARCHAR2(7) NOT NULL Version ID
Prompt Table: GM_PROPOSAL

4 SUB_PROP_NBR Character(15) VARCHAR2(15) NOT NULL SUB_PROP_NBR

5 CERT_CODE Character(5) VARCHAR2(5) NOT NULL Certification Code
Prompt Table: GM_CERT_TBL_VW2

6 COMMENTS Long Character CLOB Comment

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit Prompt Table: SP_BU_PC_NONVW
2	PROPOSAL_ID	Character(25)	VARCHAR2(25) NOT NULL	Proposal ID Prompt Table: GM_PROP_ID_VW
3	VERSION_ID	Character(7)	VARCHAR2(7) NOT NULL	Version ID Prompt Table: GM_PROPOSAL
4	SUB_PROP_NBR	Character(15)	VARCHAR2(15) NOT NULL	SUB_PROP_NBR
5	CERT_CODE	Character(5)	VARCHAR2(5) NOT NULL	Certification Code Prompt Table: GM_CERT_TBL_VW2
6	COMMENTS	Long Character	CLOB	Comment