SCC_3CD_POL_2VW

(SQL View)

SELECT A.OPRID , A.RUN_CNTL_ID , A.EFFDT , A.PRM_ID , A.ADMIN_FUNCTION , A.CHECKLIST_CD , A.CHECKLIST_STATUS , A.SCC_THRESHOLD_DAYS FROM %Table(SCC_3CD_POL_PRM) A WHERE A.EFFDT = ( SELECT MAX(B.EFFDT) FROM %Table(SCC_3CD_POL_MGR) B WHERE A.OPRID = B.OPRID AND A.RUN_CNTL_ID = B.RUN_CNTL_ID AND B.EFFDT <= %CurrentDateIn) AND A.SCC_3C_TYPE = '2'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).

2 RUN_CNTL_ID Character(30) VARCHAR2(30) NOT NULL Run Control ID

3 EFFDT Date(10) DATE NOT NULL Effective Date
Default Value: %date

4 PRM_ID Number(3,0) SMALLINT NOT NULL Parameter ID

5 ADMIN_FUNCTION Character(4) VARCHAR2(4) NOT NULL Administrative Function

6 CHECKLIST_CD Character(6) VARCHAR2(6) NOT NULL Checklist Code

7 CHECKLIST_STATUS Character(1) VARCHAR2(1) NOT NULL Checklist Status
C=Completed
I=Initiated

8 SCC_THRESHOLD_DAYS Number(5,0) INTEGER NOT NULL Threshold (days)

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).
2	RUN_CNTL_ID	Character(30)	VARCHAR2(30) NOT NULL	Run Control ID
3	EFFDT	Date(10)	DATE NOT NULL	Effective Date Default Value: %date
4	PRM_ID	Number(3,0)	SMALLINT NOT NULL	Parameter ID
5	ADMIN_FUNCTION	Character(4)	VARCHAR2(4) NOT NULL	Administrative Function
6	CHECKLIST_CD	Character(6)	VARCHAR2(6) NOT NULL	Checklist Code
7	CHECKLIST_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Checklist Status C=Completed I=Initiated
8	SCC_THRESHOLD_DAYS	Number(5,0)	INTEGER NOT NULL	Threshold (days)