Course Hero Logo

T1sessnnbr this is the unique session number of the

Course Hero uses AI to attempt to automatically extract content from documents to surface to you and others so you can study better, e.g., in search results, to enrich docs, and more. This preview shows page 105 - 109 out of 310 pages.

T1_SESSN_NBRThis is the unique session number of the course that is being taught.This has a prompt table edit that validates against the T1_CRS_SESSN record.This required field is a key value.This field appears at level one on the page.T1_ENROLL_DTThis date field indicates when the student enrolls in the session.The default value should be the current date.Serge FORNALLAZ (sergeฺ[email protected]ฺch) has a non-transferablelicense to use this Student GuideฺUnauthorized reproduction or distribution prohibitedฺ Copyright© 2018, Oracle and/or its affiliatesฺ
Building Classic ApplicationsLesson 18620FieldExplanationT1_ENROLL_STATUSThis three-character field has four translate values:DRP (long nameDropped; short nameDrop)ENR (long nameEnrolled; short nameEnroll)RES (long nameRescheduled; short nameResched)WAT (long nameWait List; short nameWait)T1_CONFIRM_LETTERThis field indicates whether or not PSU has sent an enrollment confirmationletter to the student.The default should beNo.Serge FORNALLAZ (sergeฺ[email protected]ฺch) has a non-transferablelicense to use this Student GuideฺUnauthorized reproduction or distribution prohibitedฺ Copyright© 2018, Oracle and/or its affiliatesฺ
Lesson 18Building Classic Applications621Activity Detailed StepsPerform the detailed steps to complete the activity.Defining FieldsTo define fields:1.Use these specifications to create the new field definitions for the Student Enrollment application:Field Name and Label IDTypeLengthLong LabelT1_ENROLL_DTDateEnrollment DateT1_ENROLL_STATUSCharacter3Enrollment StatusT1_CONFIRM_LETTERCharacter1Confirmation Letter2.Save the project.Creating Record DefinitionsTo create the Student Enrollment record definition:1.Use these technical specification to create the record definition:FieldKeySrchListDefaultValueReqEditPrompt TableSTUDENT_IDKey---Yes--T1_COURSEKey---YesPromptT1_COURSE_TBLT1_SESSN_NBRKey---YesPromptT1_CRS_SESSNT1_ENROLL_DT---%DATE---T1_ENROLL_STATUS---ENRYesTranslate-T1_CONFIRM_LETTER---NYesYes/No-2.Save the record definition asT1_STU_ENROLL.3.In the Change Space dialog box, selectPTAPP.PSPTDMOfrom the Available Space Name-DB namedrop-down list.4.Save the project.Serge FORNALLAZ (sergeฺ[email protected]ฺch) has a non-transferablelicense to use this Student GuideฺUnauthorized reproduction or distribution prohibitedฺ Copyright© 2018, Oracle and/or its affiliatesฺ
Building Classic ApplicationsLesson 18622Building the SQL TablesTo build the SQL tables:1.Select Build, Current Definition.2.Select the Create Tables check box.3.Select the Execute SQL now radio button.4.Before you build the tables, click the Settings button and verify that the appropriate settings are selectedfrom previous activities.

Upload your study docs or become a

Course Hero member to access this document

Upload your study docs or become a

Course Hero member to access this document

End of preview. Want to read all 310 pages?

Upload your study docs or become a

Course Hero member to access this document

Term
Winter
Professor
NoProfessor
Tags
Oracle Corporation, PeopleSoft, LA nse t

Newly uploaded documents

Show More

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture