| # |
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
Prompt Table:
SSR_DEST_INSTVW
|
| 4 |
SSR_REF_YEAR |
Character(4) |
VARCHAR2(4) NOT NULL |
Australia DEST Processing
Prompt Table:
SSR_DEST_SET_YR
|
| 5 |
SSR_REF_YR_HALF |
Character(1) |
VARCHAR2(1) NOT NULL |
Australia DEST processing
1=First Half Year
2=Second Half Year
Default Value: 1
|
| 6 |
SSR_CENSUS_STRT_DT |
Date(10) |
DATE NOT NULL |
Australia DEST Processing
|
| 7 |
SSR_CENSUS_END_DT |
Date(10) |
DATE NOT NULL |
Australia DEST Processing
|
| 8 |
SSR_CAS_INDIC |
Character(1) |
VARCHAR2(1) NOT NULL |
Australia DEST processing
A=All Students
C=Commonwlth Asstd Students Only
N=Non Cmwlth Asstd Stdnts Only
Default Value: A
|
| 9 |
FILE_PATH |
Character(127) |
VARCHAR2(127) NOT NULL |
Input/Output file path
|
| 10 |
SSR_DEST_HALF_STDT |
Date(10) |
DATE |
Australia DEST processing
|
| 11 |
SSR_DEST_HALF_ENDT |
Date(10) |
DATE |
Australia DEST processing
|
| 12 |
SSR_CENTRELINK_SUB |
Character(1) |
VARCHAR2(1) NOT NULL |
Centrelink Submission Number
Y/N Table Edit
Default Value: N
|
| 13 |
SSR_CNTLNK_REF_NBR |
Character(1) |
VARCHAR2(1) NOT NULL |
Centrelink Submission
1=Student Submission One
2=Student Submission Two
3=Student Submission Three
4=Student Submission Four
|
| 14 |
SSR_SCHLSHIP_GRP |
Character(1) |
VARCHAR2(1) NOT NULL |
Scholarship Groups for DEST reporting
0=Commencing Only
1=Commencing and Continuing
|
| 15 |
SSR_SCHSHIP_FRM_DT |
Date(10) |
DATE |
Scholarship From Date to be used on the run control pages for DEST reporting.
|
| 16 |
SSR_SCHSHIP_TO_DT |
Date(10) |
DATE |
Scholarship To Date to be used on the run control pages for DEST reporting.
|
| 17 |
SSR_ENRL_RC_CHK |
Character(1) |
VARCHAR2(1) NOT NULL |
Pushbutton to show enrollments for DEST reporting
Y/N Table Edit
|
| 18 |
SSR_SCHP_RC_CHK |
Character(1) |
VARCHAR2(1) NOT NULL |
Pushbutton to view scholarships in DEST reporting.
Y/N Table Edit
|
| 19 |
SSR_OS_HELP_RC_CHK |
Character(1) |
VARCHAR2(1) NOT NULL |
Pushbutton to display help for OS reporting in DEST
Y/N Table Edit
|
| 20 |
SSR_PS_RC_CHK |
Character(1) |
VARCHAR2(1) NOT NULL |
Past Course check box
Y/N Table Edit
|
| 21 |
SSF_SAH_OVR_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Override Flag
N=Override Flag No
Y=Override Flag Yes
|