GP_WAREC_VW (SQL View)	Index Back
GP addtl result views n tables View of PSRECDEFN that is limited to records that contain all 7 required segment keys for GP results. These are CAL_ID CAL_RUN_ID, EMPLID, EMPL_RCD, GP_PAYGROUP, ORIG_CAL_RUN_ID, RSLT_SEG_NUM.

GP_WAREC_VW

(SQL View)

GP addtl result views n tables

View of PSRECDEFN that is limited to records that contain all 7 required segment keys for GP results. These are CAL_ID CAL_RUN_ID, EMPLID, EMPL_RCD, GP_PAYGROUP, ORIG_CAL_RUN_ID, RSLT_SEG_NUM.

SELECT RECNAME , RECDESCR , DESCRLONG FROM PSRECDEFN RD WHERE 7 = ( SELECT COUNT(*) FROM PSRECFIELDDB RF WHERE RF.RECNAME = RD.RECNAME AND FIELDNAME IN ('CAL_ID','CAL_RUN_ID','EMPLID','EMPL_RCD','GP_PAYGROUP','ORIG_CAL_RUN_ID','RSLT_SEG_NUM'))

Related Language Record: PSRECDEFNLANG

# 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

3 DESCRLONG Long Character CLOB Long Description

#	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
3	DESCRLONG	Long Character	CLOB	Long Description