EC_SETC_REC_VW |
index back |
---|---|
TableSet Record Detail |
SELECT SETCNTRLVALUE , REC_GROUP_ID , RECNAME , SETID FROM PS_SET_CNTRL_REC WHERE REC_GROUP_ID = 'HR_02' AND RECNAME IN ('JOBCODE_TBL','JOBCODE_LANG') |
PeopleSoft Field Name | Field Type | Column Type | Description |
---|---|---|---|
SETCNTRLVALUE | Character(20) | VARCHAR2(20) NOT NULL | Tree Definition User Key Value |
REC_GROUP_ID | Character(10) | VARCHAR2(10) NOT NULL |
Record Group ID
Prompt Table: REC_GROUP_TBL |
RECNAME | Character(15) | VARCHAR2(15) NOT NULL |
Record (Table) Name (see PSRECDEFN).
Prompt Table: REC_GROUP_REC |
SETID | Character(5) | VARCHAR2(5) NOT NULL |
SetID
Prompt Table: SETID_TBL |
index back | (c)David Kurtz 2020, www.go-faster.co.uk | PeopleTools 8.58 PTRef generated on 21-DEC-20 |