| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 INSTITUTION |
Character(5) |
VARCHAR2(5) NOT NULL |
Academic Institution
Default Value: OPR_DEF_TBL_CS.INSTITUTION
Prompt Table:
INSTITUTION_TBL
|
| 2 |
TSCRPT_TYPE |
Character(5) |
VARCHAR2(5) NOT NULL |
Transcript Type
|
| 3 |
EFFDT |
Date(10) |
DATE NOT NULL |
Effective Date
Default Value: %date
|
| 4 |
DESCR |
Character(30) |
VARCHAR2(30) NOT NULL |
Description
|
| 5 |
SSF_ITEM_TYPE_CC |
Character(12) |
VARCHAR2(12) NOT NULL |
Misc Fee Credit Card Item Type
Prompt Table:
ITEM_TYPE_CR_VW
|
| 6 |
SSF_ITEM_TYPE_EC |
Character(12) |
VARCHAR2(12) NOT NULL |
Misc Fee Echeck Item Type
Prompt Table:
ITEM_TYPE_EC_VW
|
| 7 |
SSR_TSCRPT_FEE_REQ |
Character(1) |
VARCHAR2(1) NOT NULL |
Transcript Fee Required flag
Y/N Table Edit
|
| 8 |
SSR_TSCRPT_PAY_REQ |
Character(1) |
VARCHAR2(1) NOT NULL |
Payment Required flag
Y/N Table Edit
|
| 9 |
SSR_TSCRPT_AMOUNT |
Number(11,2) |
DECIMAL(10,2) NOT NULL |
Transcript Flat Amount
|
| 10 |
SCC_RULE_ID |
Character(40) |
VARCHAR2(40) NOT NULL |
This field is the Rule ID for rules used in the Rules Engine
|
| 11 |
APP_TO_GL |
Character(1) |
VARCHAR2(1) NOT NULL |
Post to GL from AAWS App
Y/N Table Edit
|
| 12 |
SF_MERCHANT_ID |
Character(12) |
VARCHAR2(12) NOT NULL |
SF Merchant ID
Prompt Table:
SSF_HPMRCHCC_VW
|
| 13 |
SF_MERCHANT_ID_EC |
Character(12) |
VARCHAR2(12) NOT NULL |
SF eCheck Merchant ID
Prompt Table:
SSF_HPMRCHEC_VW
|
| 14 |
ITEM_TYPE |
Character(12) |
VARCHAR2(12) NOT NULL |
Item Type
Prompt Table:
SP_ITEMCH_NONVW
|
| 15 |
DESCRFORMAL |
Character(50) |
VARCHAR2(50) NOT NULL |
Formal Description field
|
| 16 |
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
Default Value: 20
|
| 17 |
DETAIL_ORG |
Character(1) |
VARCHAR2(1) NOT NULL |
Detail Organization
C=Order by Career
T=Chronological across Careers
Default Value: C
|
| 18 |
CHK_SRVC_IND |
Character(1) |
VARCHAR2(1) NOT NULL |
Check Service Indicators
Y/N Table Edit
Default Value: N
|
| 19 |
SRVC_IMPACT_1 |
Character(5) |
VARCHAR2(5) NOT NULL |
Service Impacts
Prompt Table:
SRVC_IMPACT_VW
|
| 20 |
SRVC_IMPACT_2 |
Character(5) |
VARCHAR2(5) NOT NULL |
Service Impact to Check
Prompt Table:
SRVC_IMPACT_VW
|
| 21 |
SRVC_IMPACT_3 |
Character(5) |
VARCHAR2(5) NOT NULL |
Service Impact to Check
Prompt Table:
SRVC_IMPACT_VW
|
| 22 |
INSTITUTION_PA |
Character(2) |
VARCHAR2(2) NOT NULL |
Institution Print Area
Default Value: ND
Prompt Table:
PRINT_AREA_VW1
|
| 23 |
INSTITUTION_PN |
Number(3,0) |
SMALLINT NOT NULL |
Institution Print Area Seq
|
| 24 |
INST_ADDR |
Character(1) |
VARCHAR2(1) NOT NULL |
Print Institution Address
Y/N Table Edit
Default Value: N
|
| 25 |
INST_ID_FL |
Character(1) |
VARCHAR2(1) NOT NULL |
Print Institution ID
Y/N Table Edit
Default Value: N
|
| 26 |
INST_ID |
Character(6) |
VARCHAR2(6) NOT NULL |
Institution ID
|
| 27 |
STDNT_ID_PA |
Character(2) |
VARCHAR2(2) NOT NULL |
Student Information Print Area
Default Value: ND
Prompt Table:
PRINT_AREA_VW1
|
| 28 |
STDNT_ID_PN |
Number(3,0) |
SMALLINT NOT NULL |
Student Info Print Area Seq
|
| 29 |
STDNT_SSN |
Character(1) |
VARCHAR2(1) NOT NULL |
Print Student SSN
Y/N Table Edit
Default Value: N
|
| 30 |
STDNT_BDAY |
Character(1) |
VARCHAR2(1) NOT NULL |
Print Student Birthday
Y/N Table Edit
Default Value: N
|
| 31 |
STDNT_SEX |
Character(1) |
VARCHAR2(1) NOT NULL |
Print Student Sex
Y/N Table Edit
Default Value: N
|
| 32 |
STDNT_ADDR |
Character(1) |
VARCHAR2(1) NOT NULL |
Print Student Address
Y/N Table Edit
Default Value: N
|
| 33 |
ADDR_USAGE |
Character(10) |
VARCHAR2(10) NOT NULL |
Address Usage
Prompt Table:
ADDR_USAGE_TBL
|
| 34 |
SSR_STDNT_PHONE_FL |
Character(1) |
VARCHAR2(1) NOT NULL |
Print Student Phone
Y/N Table Edit
Default Value: N
|
| 35 |
SSR_PHONE_USAGE |
Character(10) |
VARCHAR2(10) NOT NULL |
Phone Usage
Prompt Table:
PHONE_USAGE_TBL
|
| 36 |
NAME_USAGE |
Character(10) |
VARCHAR2(10) NOT NULL |
Name Usage
Prompt Table:
NAME_USAGE_TBL
|
| 37 |
SSR_CAMPUS_ID_FL |
Character(1) |
VARCHAR2(1) NOT NULL |
Print Campus ID
Y/N Table Edit
Default Value: N
|
| 38 |
ADM_PA |
Character(2) |
VARCHAR2(2) NOT NULL |
Admit Term Print Area
Default Value: ND
Prompt Table:
PRINT_AREA_VW2
|
| 39 |
ADM_PN |
Number(3,0) |
SMALLINT NOT NULL |
Admit Term Print Area Seq
|
| 40 |
ATT_PA |
Character(2) |
VARCHAR2(2) NOT NULL |
Attendance Dates Print Area
Default Value: ND
Prompt Table:
PRINT_AREA_VW2
|
| 41 |
ATT_PN |
Number(3,0) |
SMALLINT NOT NULL |
Attendance Dates Print Seq
|
| 42 |
LOCAL_DEGR_PA |
Character(2) |
VARCHAR2(2) NOT NULL |
Local Degrees Print Area
Default Value: ND
Prompt Table:
PRINT_AREA_VW3
|
| 43 |
LOCAL_DEGR_PN |
Number(3,0) |
SMALLINT NOT NULL |
Local Degrees Print Area Seq
|
| 44 |
LOCAL_DEGR_GPA |
Character(1) |
VARCHAR2(1) NOT NULL |
Print Degree GPA
Y/N Table Edit
Default Value: N
|
| 45 |
LOCAL_DEGR_RANK |
Character(1) |
VARCHAR2(1) NOT NULL |
Print Degree Rank
Y/N Table Edit
Default Value: N
|
| 46 |
LOCAL_DEGR_HONORS |
Character(1) |
VARCHAR2(1) NOT NULL |
Print Degree Honors
Y/N Table Edit
Default Value: N
|
| 47 |
LOCAL_DEGR_PL_GPA |
Character(1) |
VARCHAR2(1) NOT NULL |
Print Degree Plan GPA
Y/N Table Edit
Default Value: N
|
| 48 |
LOCAL_DEGR_PL_RANK |
Character(1) |
VARCHAR2(1) NOT NULL |
Print Degree Plan Rank
Y/N Table Edit
Default Value: N
|
| 49 |
LOCAL_DEGR_SUBPLAN |
Character(1) |
VARCHAR2(1) NOT NULL |
Print Degree Sub-Plan
Y/N Table Edit
Default Value: N
|
| 50 |
PROG_PA |
Character(2) |
VARCHAR2(2) NOT NULL |
Academic Program Print Area
Default Value: ND
Prompt Table:
PRINT_AREA_VW4
|
| 51 |
PROG_PN |
Number(3,0) |
SMALLINT NOT NULL |
Academic Program Print Seq
|
| 52 |
PROG_ST_APPLICANT |
Character(1) |
VARCHAR2(1) NOT NULL |
Prog Status - Applicant
Y/N Table Edit
Default Value: N
|
| 53 |
PROG_ST_WAITLISTED |
Character(1) |
VARCHAR2(1) NOT NULL |
Prog Status - Waitlisted
Y/N Table Edit
Default Value: N
|
| 54 |
PROG_ST_ADMITTED |
Character(1) |
VARCHAR2(1) NOT NULL |
Prog Status - Admitted
Y/N Table Edit
Default Value: N
|
| 55 |
PROG_ST_PREMATRIC |
Character(1) |
VARCHAR2(1) NOT NULL |
Prog Status - Prematric
Y/N Table Edit
Default Value: N
|
| 56 |
PROG_ST_ACTIVE |
Character(1) |
VARCHAR2(1) NOT NULL |
Prog Status - Active
Y/N Table Edit
Default Value: Y
|
| 57 |
PROG_ST_CANCELLED |
Character(1) |
VARCHAR2(1) NOT NULL |
Prog Status - Cancelled
Y/N Table Edit
Default Value: N
|
| 58 |
PROG_ST_DISCONTD |
Character(1) |
VARCHAR2(1) NOT NULL |
Prog Status - Discontinued
Y/N Table Edit
Default Value: N
|
| 59 |
PROG_ST_COMPLETED |
Character(1) |
VARCHAR2(1) NOT NULL |
Prog Status - Completed
Y/N Table Edit
Default Value: N
|
| 60 |
PROG_ST_LOA |
Character(1) |
VARCHAR2(1) NOT NULL |
Prog Status - LOA
Y/N Table Edit
Default Value: N
|
| 61 |
PROG_ST_SUSPENDED |
Character(1) |
VARCHAR2(1) NOT NULL |
Prog Status - Suspended
Y/N Table Edit
Default Value: N
|
| 62 |
PROG_ST_DISMISSED |
Character(1) |
VARCHAR2(1) NOT NULL |
Prog Status - Dismissed
Y/N Table Edit
Default Value: N
|
| 63 |
PROG_ST_DECEASED |
Character(1) |
VARCHAR2(1) NOT NULL |
Prog Status - Deceased
Y/N Table Edit
Default Value: N
|
| 64 |
PROG_PRT |
Character(1) |
VARCHAR2(1) NOT NULL |
What to Print
A=Active Program for Term
P=All Plan Changes
S=Changes in Program Status
Default Value: S
|
| 65 |
PROG_PLAN |
Character(1) |
VARCHAR2(1) NOT NULL |
Print Plans with Program
Y/N Table Edit
Default Value: N
|
| 66 |
SSR_TSTYPE_SUBPLAN |
Character(1) |
VARCHAR2(1) NOT NULL |
Print Subplans
Y/N Table Edit
Default Value: N
|
| 67 |
ENRL_PA |
Character(2) |
VARCHAR2(2) NOT NULL |
Enrollment Print Area
Default Value: ND
Prompt Table:
PRINT_AREA_VW7
|
| 68 |
ENRL_PN |
Number(3,0) |
SMALLINT NOT NULL |
Enrollment Print Area Seq
|
| 69 |
ENRL_PRT_TERM |
Character(1) |
VARCHAR2(1) NOT NULL |
Term Title to Use
L=Long Description
S=Short Description
|
| 70 |
ENRL_CRSE_TOPIC |
Character(1) |
VARCHAR2(1) NOT NULL |
Print Course Topic
Y/N Table Edit
Default Value: N
|
| 71 |
ENRL_CRSE_ATTR |
Character(1) |
VARCHAR2(1) NOT NULL |
Print Course Attributes
Y/N Table Edit
Default Value: N
|
| 72 |
SSR_ENRL_CONTACTHR |
Character(1) |
VARCHAR2(1) NOT NULL |
Print Contact Hours
Y/N Table Edit
Default Value: N
|
| 73 |
ENRL_INSTRUCTOR |
Character(1) |
VARCHAR2(1) NOT NULL |
Print Instructor Name
Y/N Table Edit
Default Value: N
|
| 74 |
ENRL_TSCRPT_NOTES |
Character(1) |
VARCHAR2(1) NOT NULL |
Print Transcript Notes
Y/N Table Edit
Default Value: N
|
| 75 |
ENRL_SORT |
Character(1) |
VARCHAR2(1) NOT NULL |
Course List Sort Order
C=Subj Area and Catlg Nbr
S=Session / Subj
|
| 76 |
ENRL_SESSION |
Character(1) |
VARCHAR2(1) NOT NULL |
Session Title to Use
L=Long Description
S=Short Description
|
| 77 |
ENRL_CLASS_END_DT |
Character(1) |
VARCHAR2(1) NOT NULL |
Print Class Dates
Y/N Table Edit
Default Value: N
|
| 78 |
ENRL_OEE_CLASS_DT |
Character(1) |
VARCHAR2(1) NOT NULL |
Print OEE Class Dates
Y/N Table Edit
Default Value: N
|
| 79 |
ENRL_OBEY_ENPRT_DT |
Character(1) |
VARCHAR2(1) NOT NULL |
Obey Enrllmnt on Transcript Dt
Y/N Table Edit
Default Value: N
|
| 80 |
ENRL_OBEY_FGRD_DT |
Character(1) |
VARCHAR2(1) NOT NULL |
Obey Fully Graded Date
Y/N Table Edit
Default Value: N
|
| 81 |
ENRL_HIST_DATA |
Character(1) |
VARCHAR2(1) NOT NULL |
Include Historical Enrollment
Y/N Table Edit
|
| 82 |
TERM_STAT_PA |
Character(2) |
VARCHAR2(2) NOT NULL |
Term Statistics Print Area
Default Value: ND
Prompt Table:
PRINT_AREA_VW6
|
| 83 |
TERM_STAT_PN |
Number(3,0) |
SMALLINT NOT NULL |
Term Stat Print Area Seq
|
| 84 |
TERM_STAT_OBEY_DT |
Character(1) |
VARCHAR2(1) NOT NULL |
Obey Show Stats on Tscript Dt
Y/N Table Edit
Default Value: N
|
| 85 |
SSR_TERMSTAT_TRFCR |
Character(1) |
VARCHAR2(1) NOT NULL |
Print Transfer Credit Stats
Y/N Table Edit
Default Value: N
|
| 86 |
CUM_STAT_EOT |
Character(1) |
VARCHAR2(1) NOT NULL |
Print Cums at End of Term
Y/N Table Edit
Default Value: N
|
| 87 |
CUM_STAT_COP |
Character(1) |
VARCHAR2(1) NOT NULL |
Print Cums at Change of Pgm
Y/N Table Edit
Default Value: N
|
| 88 |
CUM_STAT_EOX |
Character(1) |
VARCHAR2(1) NOT NULL |
Print Cums at End of Tscript
Y/N Table Edit
Default Value: N
|
| 89 |
TERM_HON_PA |
Character(2) |
VARCHAR2(2) NOT NULL |
Term Honors Print Area
Default Value: ND
Prompt Table:
PRINT_AREA_VW6
|
| 90 |
TERM_HON_PN |
Number(3,0) |
SMALLINT NOT NULL |
Term Honors Print Area Seq
|
| 91 |
ACAD_STDNG_PA |
Character(2) |
VARCHAR2(2) NOT NULL |
Academic Standing Print Area
Default Value: ND
Prompt Table:
PRINT_AREA_VW6
|
| 92 |
ACAD_STDNG_PN |
Number(3,0) |
SMALLINT NOT NULL |
Academic Standing Print Seq
|
| 93 |
WITHDRAWAL_PA |
Character(2) |
VARCHAR2(2) NOT NULL |
Withdrawal Info Print Area
Default Value: ND
Prompt Table:
PRINT_AREA_VW7
|
| 94 |
WITHDRAWAL_PN |
Number(3,0) |
SMALLINT NOT NULL |
Withdrawal Info Print Area Seq
|
| 95 |
MILESTONE_PA |
Character(2) |
VARCHAR2(2) NOT NULL |
Milestones Print Area
Default Value: ND
Prompt Table:
PRINT_AREA_VW8
|
| 96 |
MILESTONE_PN |
Number(3,0) |
SMALLINT NOT NULL |
Milestones Print Area Seq
|
| 97 |
ISSUE_PRTDT_PA |
Character(2) |
VARCHAR2(2) NOT NULL |
Issuance Print Date Print Area
Default Value: ND
Prompt Table:
PRINT_AREA_VW1
|
| 98 |
ISSUE_PRTDT_PN |
Number(3,0) |
SMALLINT NOT NULL |
Issuance Print Area Seq
|
| 99 |
ISSUE_RQSTR_PA |
Character(2) |
VARCHAR2(2) NOT NULL |
Requester Print Area
Default Value: ND
Prompt Table:
PRINT_AREA_VW2
|
| 100 |
ISSUE_RQSTR_PN |
Number(3,0) |
SMALLINT NOT NULL |
Requester Print Area Seq
|
| 101 |
ISSUE_REASON_PA |
Character(2) |
VARCHAR2(2) NOT NULL |
Request Reason Print Area
Default Value: ND
Prompt Table:
PRINT_AREA_VW2
|
| 102 |
ISSUE_REASON_PN |
Number(3,0) |
SMALLINT NOT NULL |
Request Reason Print Area Seq
|
| 103 |
ISSUE_RECIPIENT_PA |
Character(2) |
VARCHAR2(2) NOT NULL |
Recipient Print Area
Default Value: ND
Prompt Table:
PRINT_AREA_VW2
|
| 104 |
ISSUE_RECIPIENT_PN |
Number(3,0) |
SMALLINT NOT NULL |
Recipient Print Area Seq
|
| 105 |
EXT_INST_ATT_PA |
Character(2) |
VARCHAR2(2) NOT NULL |
Other Institutions Attended PA
Default Value: ND
Prompt Table:
PRINT_AREA_VW2
|
| 106 |
EXT_INST_ATT_PN |
Number(3,0) |
SMALLINT NOT NULL |
Other Inst Att Print Area Seq
|
| 107 |
EXT_DEGR_PA |
Character(2) |
VARCHAR2(2) NOT NULL |
External Degrees Print Area
Default Value: ND
Prompt Table:
PRINT_AREA_VW2
|
| 108 |
EXT_DEGR_PN |
Number(3,0) |
SMALLINT NOT NULL |
External Degree Print Area Seq
|
| 109 |
EXT_DEGR_HONS |
Character(1) |
VARCHAR2(1) NOT NULL |
Print Honors
Y/N Table Edit
Default Value: N
|
| 110 |
TRNSFR_CR_PA |
Character(2) |
VARCHAR2(2) NOT NULL |
Transfer Credit Print Area
Default Value: ND
Prompt Table:
PRINT_AREA_VW10
|
| 111 |
TRNSFR_CR_PN |
Number(3,0) |
SMALLINT NOT NULL |
Transfer Credit Print Area Seq
|
| 112 |
TRNSFR_CR_I_LEVEL |
Character(1) |
VARCHAR2(1) NOT NULL |
Level of Detail
D=Detail
S=Summary
|
| 113 |
TRNSFR_CR_I_DETAIL |
Character(1) |
VARCHAR2(1) NOT NULL |
Details to Print
B=External and Internal
E=External Courses
I=Internal Equivalent Course
|
| 114 |
TRNSFR_CR_C_LEVEL |
Character(1) |
VARCHAR2(1) NOT NULL |
Level of Detail
D=Detail
S=Summary
|
| 115 |
TRNSFR_CR_C_DETAIL |
Character(1) |
VARCHAR2(1) NOT NULL |
Details to Print
B=External and Internal
E=External Courses
I=Internal Equivalent Course
|
| 116 |
TRNSFR_CR_OBEY_EXT |
Character(1) |
VARCHAR2(1) NOT NULL |
Obey External Org Parms
Y/N Table Edit
|
| 117 |
TRNSFR_CR_LEVEL |
Character(1) |
VARCHAR2(1) NOT NULL |
Level of Detail
D=Detail
S=Summary
|
| 118 |
TRNSFR_CR_DETAIL |
Character(1) |
VARCHAR2(1) NOT NULL |
Details to Print
B=External and Internal
E=External Courses
I=Internal Equivalent Course
|
| 119 |
TRNSFR_CR_POSTED |
Character(1) |
VARCHAR2(1) NOT NULL |
Print Posted Models Only
Y/N Table Edit
Default Value: N
|
| 120 |
TEST_CR_PA |
Character(2) |
VARCHAR2(2) NOT NULL |
Test Print Area
Default Value: ND
Prompt Table:
PRINT_AREA_VW9
|
| 121 |
TEST_CR_PN |
Number(3,0) |
SMALLINT NOT NULL |
Test Print Area Seq
|
| 122 |
TEST_CR_LEVEL |
Character(1) |
VARCHAR2(1) NOT NULL |
Level of Detail
D=Detail
S=Summary
|
| 123 |
TEST_CR_DETAIL |
Character(1) |
VARCHAR2(1) NOT NULL |
Details to Print
B=Test and Internal Equiv
E=Test Credits
I=Internal Equivalent Course
|
| 124 |
TEST_CR_POSTED |
Character(1) |
VARCHAR2(1) NOT NULL |
Print Posted Models Only
Y/N Table Edit
Default Value: N
|
| 125 |
OTHER_CR_PA |
Character(2) |
VARCHAR2(2) NOT NULL |
Other Credits Print Area
Default Value: ND
Prompt Table:
PRINT_AREA_VW9
|
| 126 |
OTHER_CR_PN |
Number(3,0) |
SMALLINT NOT NULL |
Other Credits Print Area Seq
|
| 127 |
OTHER_CR_LEVEL |
Character(1) |
VARCHAR2(1) NOT NULL |
Level of Detail
D=Detail
S=Summary
|
| 128 |
OTHER_CR_DETAIL |
Character(1) |
VARCHAR2(1) NOT NULL |
Details to Print
B=Other Cr and Internal
E=Other Credits
I=Internal Equivalent Course
|
| 129 |
OTHER_CR_POSTED |
Character(1) |
VARCHAR2(1) NOT NULL |
Print Posted Models Only
Y/N Table Edit
Default Value: N
|
| 130 |
BOM_PA |
Character(2) |
VARCHAR2(2) NOT NULL |
BOM Print Area
Default Value: ND
Prompt Table:
PRINT_AREA_VW2
|
| 131 |
BOM_PN |
Number(3,0) |
SMALLINT NOT NULL |
BOM Print Area Seq
|
| 132 |
AWARD_PA |
Character(2) |
VARCHAR2(2) NOT NULL |
Award Print Area
Default Value: ND
Prompt Table:
PRINT_AREA_VW2
|
| 133 |
AWARD_PN |
Number(3,0) |
SMALLINT NOT NULL |
Award Print Seq
|
| 134 |
AWARD_AID_YEAR_PRT |
Character(1) |
VARCHAR2(1) NOT NULL |
Print Aid Year
Y/N Table Edit
Default Value: N
|
| 135 |
AWARD_AMOUNT_PRT |
Character(1) |
VARCHAR2(1) NOT NULL |
Print Amount
A=Accepted Amount
D=Disbursed Amount
|
| 136 |
SSR_TESTSCORE_PA |
Character(2) |
VARCHAR2(2) NOT NULL |
Test Score Print Area
Default Value: ND
Prompt Table:
PRINT_AREA_VW2
|
| 137 |
SSR_TESTSCORE_PN |
Number(3,0) |
SMALLINT NOT NULL |
Test Score Print Area Seq
|
| 138 |
SSR_TESTSCORE_LAST |
Character(1) |
VARCHAR2(1) NOT NULL |
Latest Test Only
Y/N Table Edit
Default Value: N
|
| 139 |
SSR_SPCL_GPA_PA |
Character(2) |
VARCHAR2(2) NOT NULL |
Special GPA Print Area
Default Value: ND
Prompt Table:
PRINT_AREA_VW6
|
| 140 |
SSR_SPCL_GPA_PN |
Number(3,0) |
SMALLINT NOT NULL |
Special GPA Print Area Seq
|
| 141 |
SSR_ACADPROJECT_PA |
Character(2) |
VARCHAR2(2) NOT NULL |
Project Print Area
Default Value: ND
Prompt Table:
PRINT_AREA_VW2
|
| 142 |
SSR_ACADPROJECT_PN |
Number(3,0) |
SMALLINT NOT NULL |
Project Print Aea Seq
|
| 143 |
SSR_THESIS_PA |
Character(2) |
VARCHAR2(2) NOT NULL |
Thesis Print Area
Default Value: ND
Prompt Table:
PRINT_AREA_VW2
|
| 144 |
SSR_THESIS_PN |
Number(3,0) |
SMALLINT NOT NULL |
Thesis Print Area Seq
|
| 145 |
SS_STDNT_AVAIL_TP |
Character(1) |
VARCHAR2(1) NOT NULL |
Checkbox variable for a view to retrieve valid transcript types for student self-service applications.
Y/N Table Edit
Default Value: N
|
| 146 |
SS_ADVIS_AVAIL_TP |
Character(1) |
VARCHAR2(1) NOT NULL |
Checkbox variable for a view to retrieve valid transcript types for advisor self-service applications.
Y/N Table Edit
Default Value: N
|
| 147 |
TERM_ACTIVE_ONLY |
Character(1) |
VARCHAR2(1) NOT NULL |
Term Activated Careers Only
Y/N Table Edit
Default Value: N
|
| 148 |
SSR_SORT_MLSTN |
Character(1) |
VARCHAR2(1) NOT NULL |
Sort Milestones by Program on the Transcript
Y/N Table Edit
Default Value: N
|
| 149 |
INFO_FOR_STDNTS |
Long Character |
CLOB |
A long text used by transcript type table used to display a message to students using the self-service transcript request pages.
|
| 150 |
SSR_TSRPT_FERPA |
Character(50) |
VARCHAR2(50) NOT NULL |
FERPA information on transcript report
|
| 151 |
SSR_ALLOW_XMLOUT |
Character(1) |
VARCHAR2(1) NOT NULL |
Allow XML Output File
Y/N Table Edit
Default Value: N
|
| 152 |
REPORT_DEFN_ID |
Character(12) |
VARCHAR2(12) NOT NULL |
Report Name (see PSXPRPTDEFN).
Prompt Table:
SSR_TSRPTDFN_VW
|
| 153 |
TMPLDEFN_ID |
Character(30) |
VARCHAR2(30) NOT NULL |
Template ID (see PSXPTMPLDEFN).
Prompt Table:
PSXPRPTTMPL_VW1
|