FO_RAPID_HDR_VW

(SQL View)
Index Back

Staffing Rapid Time Search


SELECT H.ST_INSTANCE ,H.DESCR ,H.RAPID_TMPLT_ID ,H.OPRID FROM PS_TL_RAPID_HEADER H , PS_FO_RAPD_TMP_VW T WHERE H.RAPID_TMPLT_ID = T.RAPID_TMPLT_ID

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 ST_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Session Number

Default Value: 9999999999

2 DESCR Character(30) VARCHAR2(30) NOT NULL Description
3 RAPID_TMPLT_ID Character(10) VARCHAR2(10) NOT NULL Rapid Time Template
4 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).