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 NameField TypeColumn TypeDescription
    SETCNTRLVALUECharacter(20)VARCHAR2(20) NOT NULLTree Definition User Key Value
    REC_GROUP_IDCharacter(10)VARCHAR2(10) NOT NULLRecord Group ID

    Prompt Table: REC_GROUP_TBL

    RECNAMECharacter(15)VARCHAR2(15) NOT NULLRecord (Table) Name (see PSRECDEFN).

    Prompt Table: REC_GROUP_REC

    SETIDCharacter(5)VARCHAR2(5) NOT NULLSetID

    Prompt Table: SETID_TBL

    index back(c)David Kurtz 2019, www.go-faster.co.ukPeopleTools 8.54
    PTRef generated on 09-JUN-19