GB_REC_FIELD_VW

(SQL View)
 Index Back

GB Rec Fields - Records View

Group Build Records and Fields - Records View Prompt table for the field GB_REC_FIELD.RECNAME. The view makes sure that the user can only select records that are allowed for the Group Build Records and Fields.

SELECT RECNAME , RECDESCR FROM PSRECDEFN WHERE RECNAME IN ('PERSON' ,'PERS_DATA_EFFDT' ,'PERS_DATA_BRA' ,'PERS_DATA_IND' ,'PERS_DATA_MEX' ,'PERS_DATA_CAN' ,'PERS_DATA_CHE' ,'PERS_DATA_DEU' ,'PERS_DATA_ESP' ,'PERS_DATA_FRA' ,'PERS_DATA_ITA' ,'PERS_DATA_JPN' ,'PERS_DATA_USA' ,'PERS_DATA_USF' ,'PERS_DATA_FPS' ,'PER_ORG_ASGN' ,'PER_ORG_ASG_BEL' ,'PER_ORG_ASG_BRA' ,'PER_ORG_ASG_HP' ,'PER_ORG_ASG_JPN' ,'PER_ORG_ASG_NLD' , 'PER_ORG_ASG_FA', 'PER_ORG_INST' , 'DED_NA' ,'JOB' ,'JOB_AUS' ,'JOB_IND', 'JOB_USF' ,'JOB_JR' ,'COMPENSATION' ,'TL_EMPL_DATA', 'NAMES')

  • Related Language Record: GB_REC_FLDVW_LN

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 RECNAME Character(15) VARCHAR2(15) NOT NULL Record (Table) Name (see PSRECDEFN).
    2 RECDESCR Character(30) VARCHAR2(30) NOT NULL Record Description