SSR_RS_OTRQSSVW (SQL View)	Index Back
Assignment Type prompt for 3C used as prompt in COMM_VAR_DATA 3Cs subrecord

SSR_RS_OTRQSSVW

(SQL View)

Assignment Type prompt for 3C

used as prompt in COMM_VAR_DATA 3Cs subrecord

SELECT DISTINCT A.emplid ,A.SSR_RS_CANDIT_NBR ,A.ssr_Rs_rquire_type , %Coalesce(%trimsubstr(B.SSR_RS_DESCR50,1,50) , B.DESCR100) FROM %Table(SSR_RS_OTHR_REQ) A JOIN %Table(SSR_RS_REQTYPE) B ON A.institution=B.institution AND A.SSR_RS_RQUIRE_TYPE=B.SSR_RS_RQUIRE_TYPE WHERE %EffdtCheck(SSR_RS_REQTYPE ef1,B,%currentdatein) AND B.SSR_RS_TM_SS_LBL ='Y'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

2 SSR_RS_CANDIT_NBR Character(12) VARCHAR2(12) NOT NULL Last Candidate Number

3 SSR_RS_RQUIRE_TYPE Character(2) VARCHAR2(2) NOT NULL Field to hold Research Assignment Types

4 DESCR100 Character(100) VARCHAR2(100) NOT NULL Length 100 Description

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
2	SSR_RS_CANDIT_NBR	Character(12)	VARCHAR2(12) NOT NULL	Last Candidate Number
3	SSR_RS_RQUIRE_TYPE	Character(2)	VARCHAR2(2) NOT NULL	Field to hold Research Assignment Types
4	DESCR100	Character(100)	VARCHAR2(100) NOT NULL	Length 100 Description