STD_COMM_CVT

(SQL Table)
Index Back

Std Comments Table - Purch

Upgrade table. Should be dropped after running upgrade.

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

Default Value: OPR_DEF_TBL_FS.SETID

Prompt Table: SP_SETID_NONVW

2 STD_COMMENT_TYPE Character(3) VARCHAR2(3) NOT NULL Standard Comment Type

Prompt Table: STD_COMM_TYP_PO

3 STD_COMMENT_ID Character(4) VARCHAR2(4) NOT NULL Standard Comment ID
4 EFFDT Date(10) DATE NOT NULL Effective Date

Default Value: %date

5 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
A=Active
I=Inactive

Default Value: A

6 DESCR Character(30) VARCHAR2(30) NOT NULL Description
7 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description
8 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
9 COMMENT_ID DateTime(26) TIMESTAMP DtTm Entered
10 RANDOM_CMMT_NBR Number(4,0) SMALLINT NOT NULL Random Comments Number
11 COMMENTS_2000 Long Character CLOB Comment Text