WS_ID_ITEM

(SQL Table)
Index Back

Worksheet Item Identification

Worksheet Item Identification

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 WS_BU Character(5) VARCHAR2(5) NOT NULL Worksheet Business Unit
2 WS_ID Character(15) VARCHAR2(15) NOT NULL Worksheet ID
3 ID_SEQ_NUM Number(5,0) INTEGER NOT NULL Identification Sequence number
4 REF_QUALIFIER_CODE Character(2) VARCHAR2(2) NOT NULL Reference Qualifier Code

Prompt Table: AR_FLD_REF_VW

5 REF_VALUE Character(30) VARCHAR2(30) NOT NULL Reference

Prompt Table: %EDITTABLE

6 REF_VALUE_TO Character(30) VARCHAR2(30) NOT NULL Range for Reference Value

Prompt Table: %EDITTABLE