WS_ID_ITEM(SQL Table) |
Index Back |
---|---|
Worksheet Item IdentificationWorksheet 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 |