SSR_DEEWR_AOPRG

(SQL Table)
Index Back

DEEWR AO Purge Record

DEEWR AO Purge Record

# 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 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution

Default Value: OPR_DEF_TBL_CS.INSTITUTION

Prompt Table: SCRTY_TBL_INST

4 SSR_REF_YEAR Character(4) VARCHAR2(4) NOT NULL Australia DEST Processing

Prompt Table: SSR_DEEWR_RF_VW

5 SSR_DEEWR_REFYRTO Character(4) VARCHAR2(4) NOT NULL Reference Year To

Prompt Table: SSR_DEEWR_RF_VW

6 SSR_DEEWR_RPT_PRD Number(2,0) SMALLINT NOT NULL Reporting Period

Prompt Table: SSR_DEEWR_RP_VW

7 SSR_DEEWR_RPTPRDTO Number(2,0) SMALLINT NOT NULL Reporing Period To

Prompt Table: SSR_DEEWR_RP_VW

8 SSR_DEEWR_PROFILE Character(10) VARCHAR2(10) NOT NULL Profile

Prompt Table: SSR_DEEWR_PR_VW

9 SSR_DEEWR_REFDATE Date(10) DATE Reference Date
10 SSR_DEEWR_REFDTTO Date(10) DATE Reference Date To