GPFR_DNAC_SRCH

(SQL View)
Index Back

Search Record for DNAC Update

Search Record for DNAC Update Component

SELECT DISTINCT %Substring(A.GPFR_AF_UF_01, 1, 30) , %Substring(A.GPFR_AF_UF_02, 1, 18) , %Sql(GP_CHAR_TO_NUM, A.GPFR_AF_UF_03) , A.GPFR_AF_EXTRACT_ID FROM PS_GPFR_AF_EE_LIST A

# 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 CAL_RUN_ID Character(18) VARCHAR2(18) NOT NULL Calendar Run Id
3 GPFR_AF_SEQ_NUM Number(5,0) INTEGER NOT NULL Sequence Number
4 GPFR_AF_EXTRACT_ID Character(18) VARCHAR2(18) NOT NULL Application Framework - Extraction ID