RYED_DOC_NAME

(SQL View)
Index Back

RYED_DOC_NAME

RYED_DOC_NAME - For Testing Purposes only

SELECT A.RY_DOC_ID , B.RY_MD_ID , B.RY_DATA_NAME FROM PS_RYEDOC A , PS_RYEMDATA B WHERE A.RY_MD_ID = B.RY_MD_ID

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 RY_DOC_ID Number(18,0) DECIMAL(18) NOT NULL Document ID - Dialog Document Main Sys ID
2 RY_MD_ID Number(18,0) DECIMAL(18) NOT NULL Metadata ID - Dialog document metadata table
3 RY_DATA_NAME Character(80) VARCHAR2(80) NOT NULL Document Name - Dialog Document, OLM