AM_CON_PRG_VW (SQL View)	Index Back
PROGRAM_CODE Selects the PROGRAM_CODE from those entries in INTFC PHY A with load status NEW.

AM_CON_PRG_VW

(SQL View)

PROGRAM_CODE

Selects the PROGRAM_CODE from those entries in INTFC PHY A with load status NEW.

SELECT DISTINCT %Sql(PROGRAM_CODE, A.) FROM PS_INTFC_PHY_A A WHERE A.LOAD_STATUS = 'NEW' AND %Sql(PROGRAM_CODE, A.) <> ' '

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 PROGRAM_CODE Character(5) VARCHAR2(5) NOT NULL Program Code ChartField