| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 PROCESS_INSTANCE |
Number(10,0) |
DECIMAL(10) NOT NULL |
Process Instance
|
| 2 |
OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
A user's ID (see PSOPRDEFN).
|
| 3 |
RUN_CNTL_ID |
Character(30) |
VARCHAR2(30) NOT NULL |
Run Control ID
|
| 4 |
SCCPS_POP_SEL |
Character(1) |
VARCHAR2(1) NOT NULL |
Population Selection checkbox - used to incidate on run controls that pop selection was selected for use.
Y/N Table Edit
Default Value: Y
|
| 5 |
SCCPS_TOOL_ID |
Number(15,0) |
DECIMAL(15) NOT NULL |
Tool ID - the unique key for a pop select tool
Prompt Table:
SCCPS_TOOL_VW
|
| 6 |
SCCPS_QUERY_NAME |
Character(50) |
VARCHAR2(50) NOT NULL |
Query / Section name used by population selection
Prompt Table:
%EDITTABLE
|
| 7 |
SCCPS_CNTXT_ID |
Number(15,0) |
DECIMAL(15) NOT NULL |
Context ID - the unique key that identifies the pop selection context
Prompt Table:
SCCPS_CNTXT_VW
|
| 8 |
ATTACHSYSFILENAME |
Character(128) |
VARCHAR2(128) NOT NULL |
Unique Sys Filename
|
| 9 |
ATTACHUSERFILE |
Character(64) |
VARCHAR2(64) NOT NULL |
Attached File
|
| 10 |
SCCPS_FILE_PATH |
Character(254) |
VARCHAR2(254) NOT NULL |
Pop Select File Path and Name
|
| 11 |
EMPLID |
Character(11) |
VARCHAR2(11) NOT NULL |
Employee ID
|
| 12 |
INSTITUTION |
Character(5) |
VARCHAR2(5) NOT NULL |
Academic Institution
Default Value: OPR_DEF_TBL_CS.INSTITUTION
Prompt Table:
INSTITUTION_TBL
|
| 13 |
ACAD_CAREER |
Character(4) |
VARCHAR2(4) NOT NULL |
Academic Career
BAC=Bachelor (NLD)
BBL=Vocational Coaching (NLD)
BOL=Vocational Training (NLD)
BUSN=Graduate Business
CNED=Continuing Education
CRED=Semester Credit
EDU=Education (NLD)
EXED=Extended Education
GRAD=Graduate
LAW=Law
MEDS=Medical School
NONA=Non Award
PGRD=Postgraduate
RSCH=Research
TECH=Technical
UENG=Undergraduate Engineering
UGRD=Undergraduate
VAVO=Advanced General Educ. (NLD)
VETM=Veterinary Medicine
|
| 14 |
ACAD_PROG |
Character(5) |
VARCHAR2(5) NOT NULL |
Academic Program
Prompt Table:
ACAD_PROG_TBL
|
| 15 |
ACAD_PLAN |
Character(10) |
VARCHAR2(10) NOT NULL |
Academic Plan
Prompt Table:
ACAD_PLAN_TBLVW
|
| 16 |
ASOF_DATE |
Date(10) |
DATE NOT NULL |
This field is used all over campus solutions to hold the value of an as of date to be used in different processing.
|
| 17 |
PRIOR_EFFDT |
Date(10) |
DATE |
Prior Effdt
|
| 18 |
EFFDT |
Date(10) |
DATE |
Effective Date
Default Value: %date
|
| 19 |
SSR_MLSTN_PRCS_ACT |
Character(1) |
VARCHAR2(1) NOT NULL |
This field contains the process actions available when processing milestones in batch.
B=Insert/Update Milestones
D=Delete Milestones
I=Insert Milestones
U=Update Milestones
Default Value: I
|
| 20 |
SSR_DUP_MLSTN_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
This field is used in processing batch milestones to designate which algorythm is used to determine a duplicate milestone.
1=Milestone
2=Milestone/Level
|
| 21 |
SSR_DUP_MLSTN_PRCS |
Character(1) |
VARCHAR2(1) NOT NULL |
This field is a Y/N field used in processing milestones in batch that identified if duplicate milestones should be processed or ignored.
Y/N Table Edit
|
| 22 |
SSR_USE_STDNT_SEL |
Character(1) |
VARCHAR2(1) NOT NULL |
Use Student Select
Y/N Table Edit
Default Value: N
|
| 23 |
MILESTONE_NBR |
Number(4,0) |
SMALLINT NOT NULL |
Milestone Nbr
|
| 24 |
MILESTONE |
Character(10) |
VARCHAR2(10) NOT NULL |
Milestone
Prompt Table:
MILESTONE_TBL
|
| 25 |
DESCR |
Character(30) |
VARCHAR2(30) NOT NULL |
Description
|
| 26 |
DESCRFORMAL |
Character(50) |
VARCHAR2(50) NOT NULL |
Formal Description field
|
| 27 |
MILESTONE_LEVEL |
Character(15) |
VARCHAR2(15) NOT NULL |
Milestone Level
Prompt Table:
MLSTN_LVL_TBL
|
| 28 |
MILESTONE_TITLE |
Character(254) |
VARCHAR2(254) NOT NULL |
Milestone Title
|
| 29 |
SSR_MLST_ANT_DT_CL |
Character(2) |
VARCHAR2(2) NOT NULL |
This field is used to track the calculation method used to assign a default anticipated date in milestores.
AT=Start Date of Admit Term
DC=Do Not Calculate
GE=Expected Grad Term End Date
GS=Expected Grad Term Start Date
RE=Research Final Submission Date
RS=Research Start Date
Default Value: DC
|
| 30 |
SSR_MLST_RQ_DT_CL |
Character(2) |
VARCHAR2(2) NOT NULL |
This field is used to track the calculation method used to assign a default required date in milestores.
AT=Start Date of Admit Term
DC=Do Not Calculate
GE=Expected Grad Term End Date
GS=Expected Grad Term Start Date
RE=Research Final Submission Date
RS=Research Start Date
Default Value: DC
|
| 31 |
TERM_REQUIRED |
Character(4) |
VARCHAR2(4) NOT NULL |
Term Required
Prompt Table:
TERM_TBL
|
| 32 |
DATE_REQUIRED |
Date(10) |
DATE |
Date Required
|
| 33 |
ANTICIPATED_TERM |
Character(4) |
VARCHAR2(4) NOT NULL |
Anticipated Term
Prompt Table:
TERM_TBL
|
| 34 |
ANTICIPATED_DATE |
Date(10) |
DATE |
Anticipated Date
|
| 35 |
MILESTONE_COMPLETE |
Character(1) |
VARCHAR2(1) NOT NULL |
Milestone Complete
I=In Progress
N=Not Completed
Y=Completed
|
| 36 |
HOW_COMPLETED |
Character(2) |
VARCHAR2(2) NOT NULL |
How Completed
A=Native Speaker
B=Attended Seminar
C=Submitted Work
D=Filed Petition
E=Exam Taken
|
| 37 |
DATE_COMPLETED |
Date(10) |
DATE |
Date Completed
|
| 38 |
TRANSCRIPT_LEVEL |
Character(2) |
VARCHAR2(2) NOT NULL |
Transcript level
00=Never Print
20=Print on Official
40=Print on Unofficial
60=Print on Student Life
80=Print on Degree Progress
|
| 39 |
PRNT_MLSTN_DETL |
Character(1) |
VARCHAR2(1) NOT NULL |
Print Milestone Detail
A=Always Print
N=Never Print
S=Print If Satisfied
|
| 40 |
ATTEMPTS_ALLOWED |
Number(2,0) |
SMALLINT NOT NULL |
Attempts Allowed
|
| 41 |
ADVISOR1_ID |
Character(11) |
VARCHAR2(11) NOT NULL |
Advisor/Evaluator 1
|
| 42 |
ADVISOR2_ID |
Character(11) |
VARCHAR2(11) NOT NULL |
Advisor/Evaluator 2
|
| 43 |
COMMITTEE_ADVISED |
Character(1) |
VARCHAR2(1) NOT NULL |
Advised by Committee
Y/N Table Edit
|
| 44 |
COMMITTEE_ID |
Character(6) |
VARCHAR2(6) NOT NULL |
Committee
Prompt Table:
COMMITTEE
|
| 45 |
GRADING_SCHEME |
Character(3) |
VARCHAR2(3) NOT NULL |
Grading Scheme
Prompt Table:
GRADESCHEME_TBL
|
| 46 |
GRADING_BASIS |
Character(3) |
VARCHAR2(3) NOT NULL |
Grading Basis
ANC=ABC/NC Grading
AUD=Audit
BMT=Multi-Term Course: Not Graded
CNC=Credit / No Credit
EQV=Equivalent
GRD=Graded
HSC=Hundred Point Scale (NLD)
LAW=Law
MED=Medical School Grades
NOG=No Grade Associated
NON=Non-Graded Component
NQF=NQF Scale
OPT=Student Option
PNP=Pass/Not Pass
SUS=Satisfactory/Unsatisfactory
TRN=Transfer Grading Basis
TSC=Ten Point Scale (NLD)
Prompt Table:
GRADE_BASE_D_VW
|
| 47 |
SSR_DATE |
Date(10) |
DATE |
This field is used in the application engine program to process post enrollment requisite check reports and in other processes in student records.
|
| 48 |
SSR_TIME |
Time(15) |
TIMESTAMP |
This field is used by the application engine process to process post enrollment requisite check reports and in other processes in student records.
|
| 49 |
SSR_ST_MLSTN_EXIST |
Character(11) |
VARCHAR2(11) NOT NULL |
This field is used to track if a STDNT_MLSTN record exists in the milestone batch processing
|
| 50 |
SSR_MLSTN_EXIST |
Character(11) |
VARCHAR2(11) NOT NULL |
This field is used to track if a STDNT_CAR_MLSTN record exists in the milestone batch processing
|
| 51 |
SSR_NEXT_MLSTN_NBR |
Number(4,0) |
SMALLINT NOT NULL |
This field is used to properly sequence the milestone number for a student in the batch milestone processes
|
| 52 |
SSR_RC_MLSTN_NBR |
Number(4,0) |
SMALLINT NOT NULL |
This field is used to properly sequence the milestone number for a student in the batch milestone processes
|
| 53 |
SSR_MLSTN_CNT |
Number(4,0) |
SMALLINT NOT NULL |
This field is used to properly sequence the milestones for a student in the batch milestone processes
|
| 54 |
SSR_NEXT_ATTMP_NBR |
Number(3,0) |
SMALLINT NOT NULL |
This field is used to properly sequence the milestone attempt number for a student in the batch milestone processes
|
| 55 |
SSR_ATTMPT_CNT |
Number(3,0) |
SMALLINT NOT NULL |
This field is used to properly sequence the milestone attempt for a student in the batch milestone processes
|
| 56 |
SSR_MLSTN_CURR_ACT |
Character(1) |
VARCHAR2(1) NOT NULL |
This field is used by batch milestone processing to track if the current transaction is adding or updating a STDNT_CAR_MLSTN record.
I=Insert
U=Update
|
| 57 |
ADMIT_TERM |
Character(4) |
VARCHAR2(4) NOT NULL |
Admit Term
|
| 58 |
EXP_GRAD_TERM |
Character(4) |
VARCHAR2(4) NOT NULL |
Expected Graduation Term
|
| 59 |
STRM |
Character(4) |
VARCHAR2(4) NOT NULL |
Term
|
| 60 |
TERM_BEGIN_DT |
Date(10) |
DATE |
Term Begin Date
|
| 61 |
TERM_END_DT |
Date(10) |
DATE |
Term Ending Date
|
| 62 |
CRSE_GRADE_INPUT |
Character(3) |
VARCHAR2(3) NOT NULL |
Grade Input
A=A
Prompt Table:
GRADE_REAL_VW
|
| 63 |
HOW_ATTEMPTED |
Character(2) |
VARCHAR2(2) NOT NULL |
How Attempted
A=Native Speaker
B=Attended Seminar
C=Submitted Work
D=Filed Petition
E=Exam Taken
|
| 64 |
DATE_ATTEMPTED |
Date(10) |
DATE |
Date Attempted
|
| 65 |
SSR_EMPLID |
Character(11) |
VARCHAR2(11) NOT NULL |
This field is a temporary field used to hold the emplid on a check for existance of a record for milestone batch processing
|
| 66 |
SSR_INSTITUTION |
Character(5) |
VARCHAR2(5) NOT NULL |
This field is a temporary field used to hold the emplid on a check for existance of a record for milestone batch processing
|
| 67 |
SSR_CAREER |
Character(4) |
VARCHAR2(4) NOT NULL |
This field is a temporary field used to hold the emplid on a check for existance of a record for milestone batch processing
|
| 68 |
SSR_PROG |
Character(5) |
VARCHAR2(5) NOT NULL |
This field is a temporary field used to hold the emplid on a check for existance of a record for milestone batch processing
|
| 69 |
SSR_PLAN |
Character(10) |
VARCHAR2(10) NOT NULL |
This field is a temporary field used to hold the emplid on a check for existance of a record for milestone batch processing
|
| 70 |
SSR_MILESTONE_NBR |
Number(4,0) |
SMALLINT NOT NULL |
Milestone Nbr
|
| 71 |
SSR_MLSTN_ERROR |
Character(1) |
VARCHAR2(1) NOT NULL |
This field is a Yes/No field used in the batch milestone process to determine if an error message has already been written to the log file for a student.
Y/N Table Edit
|
| 72 |
SSR_PROCESS_STDNT |
Character(1) |
VARCHAR2(1) NOT NULL |
This field is a yes/no flag used to indicate if a student needs to be processed.
Y/N Table Edit
Default Value: N
|
| 73 |
COMMENTS |
Long Character |
CLOB |
Comment
|
| 74 |
SSR_RS_BEGIN_DT |
Date(10) |
DATE |
Begin date of the current candidature.
|
| 75 |
SSR_RS_SUB_DT_MAX |
Date(10) |
DATE |
This date is the latest date for thesis submission for a research candidate.
|
| 76 |
EMPLID_SRCH |
Character(11) |
VARCHAR2(11) NOT NULL |
ID
|
| 77 |
ATTEMPT_NBR |
Number(3,0) |
SMALLINT NOT NULL |
Attempt Nbr
|
| 78 |
STDNT_CAR_NBR |
Number(3,0) |
SMALLINT NOT NULL |
Student Career Nbr
|
| 79 |
SSR_ATTMP_COMPLETE |
Character(1) |
VARCHAR2(1) NOT NULL |
Milestone Complete
|
| 80 |
HIDE_COMMENTS |
Character(1) |
VARCHAR2(1) NOT NULL |
Flag to show or hide comment on Student Self-Service
Y/N Table Edit
Default Value: N
|