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')

  • Parent record: SET_CNTRL_GROUP
  • 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