GM_ATTR_USAG_VW

(SQL View)
Index Back

Prop Attributes with usage All

Proposal Attributes

SELECT A.BUSINESS_UNIT , A.PROPOSAL_ID , A.VERSION_ID , A.ATTR_CODE , A.ATTR_CODE_VALUE , A.DESCRLONG FROM PS_GM_PROP_ATTR A , PS_GM_ATTR_CODE B WHERE A.ATTR_CODE = B.ATTR_CODE AND B.SETID = ( SELECT SETID FROM PS_SET_CNTRL_REC WHERE SETCNTRLVALUE = A.BUSINESS_UNIT AND RECNAME = 'GM_ATTR_CODE') AND B.ATTRIB_USAGE = 'L'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

Default Value: GM_AWARD.BUSINESS_UNIT

Prompt Table: SP_BU_CA_NONVW

2 PROPOSAL_ID Character(25) VARCHAR2(25) NOT NULL Proposal ID
3 VERSION_ID Character(7) VARCHAR2(7) NOT NULL Version ID
4 ATTR_CODE Character(11) VARCHAR2(11) NOT NULL ATTR_CODE

Prompt Table: GM_PROP_ATTR_VW

5 ATTR_CODE_VALUE Character(80) VARCHAR2(80) NOT NULL ATTR_CODE_VALUE
6 DESCRLONG Long Character CLOB Long Description