ST_GRP_FLD_VW

(SQL View)
 Index Back

Option Group Field View

View of All Fields available in the Option Group creation process.

SELECT A.RECNAME , A.FIELDNAME FROM PSRECFIELD A WHERE (((A.RECNAME = 'PERSON' OR A.RECNAME = 'PERS_DATA_EFFDT' OR A.RECNAME = 'PER_ORG_ASGN' OR A.RECNAME = 'JOB' OR A.RECNAME = 'ST_GRANT' OR A.RECNAME = 'ST_GRANT_VEST' OR A.RECNAME = 'ST_GRANT_EXER' OR A.RECNAME = 'ST_INSIDER_TBL') AND A.SUBRECORD = 'N') OR A.RECNAME IN ( SELECT B.FIELDNAME FROM PSRECFIELD B WHERE (B.RECNAME = 'PERSON' OR B.RECNAME = 'PERS_DATA_EFFDT' OR B.RECNAME = 'PER_ORG_ASGN' OR B.RECNAME = 'JOB' OR B.RECNAME = 'ST_GRANT' OR B.RECNAME = 'ST_GRANT_VEST' OR B.RECNAME = 'ST_GRANT_EXER' OR B.RECNAME = 'ST_INSIDER_TBL') AND B.SUBRECORD = 'Y'))

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 RECNAME Character(15) VARCHAR2(15) NOT NULL Record (Table) Name (see PSRECDEFN).
2 FIELDNAME Character(18) VARCHAR2(18) NOT NULL Field Name (see PSDBFIELD).