GM_PROP_PROF_WE

(SQL Table)
Index Back

Proposal Prof Work Experience

This record captures the proposal specific details of a professionals Prior Work Experience that is to be included/printed on a proposal.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
2 PROPOSAL_ID Character(25) VARCHAR2(25) NOT NULL Proposal ID
3 VERSION_ID Character(7) VARCHAR2(7) NOT NULL Version ID
4 SUB_PROP_NBR Character(15) VARCHAR2(15) NOT NULL SUB_PROP_NBR
5 ROW_NUMBER Number(3,0) SMALLINT NOT NULL Row_Number
6 SEQNUM Number(3,0) SMALLINT NOT NULL Sequence Number

Default Value: 10

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

Default Value: GM_PROP_PROF.EMPLID

8 START_DT Date(10) DATE Start Date

Prompt Table: GM_PRIWRK_ST_VW

9 SEQUENCE_NBR Number(2,0) SMALLINT NOT NULL Sequence Number

Default Value: 1

10 EMPLOYER Character(30) VARCHAR2(30) NOT NULL Employer