LM_LRN_D_REC_VW (SQL View)	Index Back
Learner ID Delete Record List Learner ID Delete Record List

LM_LRN_D_REC_VW

(SQL View)

Learner ID Delete Record List

SELECT A.RECNAME ,B.SQLTABLENAME , A.FIELDNAME FROM PSRECFIELD A , PSRECDEFN B WHERE A.RECNAME = B.RECNAME AND B.RECTYPE = 0 AND A.RECNAME NOT IN ( 'RUN_CNTL_LRN_DE' , 'LM_LRNR_DEL_LOG', 'LM_BO_COUNTERS' ) UNION SELECT RD1.RECNAME , RD1.SQLTABLENAME , RF2.FIELDNAME FROM PSRECDEFN RD1 , PSRECFIELD RF1 , PSRECFIELD RF2 WHERE RD1.RECNAME = RF1.RECNAME AND RD1.RECTYPE = 0 AND RF2.RECNAME = RF1.FIELDNAME AND RF1.SUBRECORD = 'Y' AND RD1.RECNAME NOT IN ( 'RUN_CNTL_LRN_DE' , 'LM_LRNR_DEL_LOG', 'LM_BO_COUNTERS' ) UNION SELECT RD1.RECNAME , RD1.SQLTABLENAME , RF3.FIELDNAME FROM PSRECDEFN RD1 , PSRECFIELD RF1 , PSRECFIELD RF2 , PSRECFIELD RF3 WHERE RD1.RECNAME = RF1.RECNAME AND RD1.RECTYPE = 0 AND RF2.RECNAME = RF1.FIELDNAME AND RF1.SUBRECORD = 'Y' AND RF3.RECNAME = RF2.FIELDNAME AND RF2.SUBRECORD = 'Y' AND RD1.RECNAME NOT IN ( 'RUN_CNTL_LRN_DE' , 'LM_LRNR_DEL_LOG', 'LM_BO_COUNTERS' )

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 RECNAME Character(15) VARCHAR2(15) NOT NULL Record (Table) Name (see PSRECDEFN).

2 SQLTABLENAME Character(18) VARCHAR2(18) NOT NULL SQL Table Name

3 FIELDNAME Character(18) VARCHAR2(18) NOT NULL Field Name (see PSDBFIELD).

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