PSA_STATUS_DEFN

(SQL Table)
Index Back

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 SETID Character(5) VARCHAR2(5) NOT NULL SetID

Prompt Table: SP_SETID_NONVW

2 STATUS_OPPORTUNITY Character(3) VARCHAR2(3) NOT NULL Opportunity Status
3 EFFDT Date(10) DATE Effective Date

Default Value: %date

4 DESCR Character(30) VARCHAR2(30) NOT NULL Description
5 SOLD_INDICATOR Character(1) VARCHAR2(1) NOT NULL Sold Indicator

Y/N Table Edit

Default Value: N