ADM_TMP3_MC

(SQL Table)
Index Back

ADMA Tmp Data for MC

ADM_TMP3_MC is used as a temporary holding area for records that a being filtered through a secondary mass change select. These records will then be inserted into ADM_TMP2_MC.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 MC_DEFN_ID Character(30) VARCHAR2(30) NOT NULL Mass Change Definition
2 MC_STATUS Character(3) VARCHAR2(3) NOT NULL Mass Change Status
APR=Approved Transaction
CAN=Cancel Transaction
ERR=Errored Transaction
PND=Pending Transaction
SCS=Successful Transaction
3 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
4 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

Prompt Table: PERSONAL_DATA

5 EFFDT Date(10) DATE Effective Date

Default Value: %date

6 EFFSEQ Number(3,0) SMALLINT NOT NULL Effective Sequence
7 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

Prompt Table: ACAD_CAR_TBL

8 ADMIN_FUNCTION Character(4) VARCHAR2(4) NOT NULL Administrative Function
9 STDNT_CAR_NBR Number(3,0) SMALLINT NOT NULL Student Career Nbr
10 ADM_APPL_NBR Character(8) VARCHAR2(8) NOT NULL Application Nbr
11 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution

Default Value: OPR_DEF_TBL_CS.INSTITUTION

Prompt Table: INSTITUTION_TBL

12 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
13 DUE_AMT Signed Number(18,2) DECIMAL(16,2) NOT NULL Due Amount
14 ADM_APPL_CTR Character(4) VARCHAR2(4) NOT NULL Application Center

Default Value: OPR_DEF_TBL_CS.ADM_APPL_CTR

Prompt Table: ADM_APPLCTR_VW

15 ADMIT_TYPE Character(3) VARCHAR2(3) NOT NULL Admit Type

Default Value: OPR_DEF_TBL_CS.ADMIT_TYPE

Prompt Table: ADMIT_TYPE_VW

16 FIN_AID_INTEREST Character(1) VARCHAR2(1) NOT NULL Financial Aid Interest

Y/N Table Edit

Default Value: N

17 HOUSING_INTEREST Character(1) VARCHAR2(1) NOT NULL Housing Interest
C=Commuter
F=Off Campus Housing
H=On Campus Housing

Default Value: H

18 NOTIFICATION_PLAN Character(4) VARCHAR2(4) NOT NULL Notification Plan
ERLY=Early Admission Decision
REG=Regular Admission Decision
ROLL=Rolling Admission

Default Value: REG

19 REGION Character(10) VARCHAR2(10) NOT NULL Region

Prompt Table: REGION_TBL

20 RECRUITER_ID Character(11) VARCHAR2(11) NOT NULL Recruiter ID

Prompt Table: RECRUITERS

21 LAST_SCH_ATTEND Character(11) VARCHAR2(11) NOT NULL Last School Attended

Prompt Table: EXT_ORG_TBL

22 ADM_APPL_COMPLETE Character(1) VARCHAR2(1) NOT NULL Application Complete

Y/N Table Edit

Default Value: N

23 GRADUATION_DT Date(10) DATE Graduation Date
24 ACADEMIC_LEVEL Character(3) VARCHAR2(3) NOT NULL Academic Level
00=Not Set
01=First Year
02=Second Year
03=Third Year
04=Fourth Year
05=Fifth Year
06=Sixth Year
10=Freshman
20=Sophomore
30=Junior
40=Senior
50=Post-Bacc Undergraduate
GR=Graduate
GRA=Graduate AUS
HON=Honours
IE=Industrial Experience
MAS=Masters
P1=Professional Year 1
P2=Professional Year 2
P3=Professional Year 3
P4=Professional Year 4
PHD=PhD
25 ACAD_PROG Character(5) VARCHAR2(5) NOT NULL Academic Program
26 PROG_STATUS Character(4) VARCHAR2(4) NOT NULL Academic Program Status
AC=Active in Program
AD=Admitted
AP=Applicant
CM=Completed Program
CN=Cancelled
DC=Discontinued
DE=Deceased
DM=Dismissed
LA=Leave of Absence
PM=Prematriculant
SP=Suspended
WT=Waitlisted
27 PROG_ACTION Character(4) VARCHAR2(4) NOT NULL Program Action
ACTV=Activate
ADMT=Admit
ADRV=Admission Revocation
APPL=Application
COMP=Completion of Program
COND=Conditional Admit
DATA=Data Change
DDEF=Defer Decision
DEFR=Defer Enrollment
DEIN=Intention to Matriculate
DENY=Deny
DISC=Discontinuation
DISM=Dismissal
LEAV=Leave of Absence
MATR=Matriculation
PLNC=Plan Change
PRGC=Program Change
RADM=Readmit
RAPP=Readmit Application
RECN=Reconsideration
REVK=Revoke Degree
RLOA=Return from Leave of Absence
SPND=Suspension
TRAN=Transfer to Other Career
VDIS=Voluntarily Discontinued
WADM=Administrative Withdrawal
WAIT=Waitlist
WAOF=Waitlist Offer
WAPP=Applicant Withdrawal
28 ACTION_DT Date(10) DATE Action Date
29 PROG_REASON Character(4) VARCHAR2(4) NOT NULL Action Reason
30 ADMIT_TERM Character(4) VARCHAR2(4) NOT NULL Admit Term
31 ACAD_LOAD_APPR Character(1) VARCHAR2(1) NOT NULL Approved Academic Load
B=Vocational Coaching (NLD)
D=Dual (NLD)
E=Part-time Vocational Tr (NLD)
F=Full-Time
O=Vocational Training (NLD)
P=Part-Time
32 CAMPUS Character(5) VARCHAR2(5) NOT NULL Campus
33 CITIZENSHIP_STATUS Character(1) VARCHAR2(1) NOT NULL Citizenship Status

Prompt Table: CITIZEN_STS_TBL

34 COMM_DIRECTION Character(4) VARCHAR2(4) NOT NULL Communication Direction
IN=Incoming Communication
OUT=Outgoing Communication
PERS=In Person
35 UNSUCCESSFUL Character(1) VARCHAR2(1) NOT NULL Unsuccessful Outcome
36 OUTCOME_REASON Character(1) VARCHAR2(1) NOT NULL Outcome Reason
C=Missing Critical Data
E=Invalid Email Address
M=Left Message on Machine
N=No Answer
O=No Org Recipients found
P=Left Message with Person
R=Returned Mail
S=Email Send Error
37 SCC_LETTER_CD Character(3) VARCHAR2(3) NOT NULL Letter Code
38 LETTER_PRINTED_DT Date(10) DATE Date letter was printed
39 LETTER_PRINTED_TM Time(15) TIMESTAMP Time Letter Printed
40 CHECKLIST_SEQ Number(6,0) INTEGER NOT NULL Checklist Sequence
41 ACAD_PLAN Character(10) VARCHAR2(10) NOT NULL Academic Plan
42 STRM Character(4) VARCHAR2(4) NOT NULL Term
43 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
44 CASHIER_OFFICE Character(8) VARCHAR2(8) NOT NULL Cashier's Office
45 GROUP_ID_SF Character(15) VARCHAR2(15) NOT NULL Group ID
46 INVOICE_ID Character(22) VARCHAR2(22) NOT NULL Invoice Number
47 LINE_SEQ_NBR Number(3,0) SMALLINT NOT NULL Line Sequence Nbr
48 PAYMENT_ID_NBR Number(12,0) DECIMAL(12) NOT NULL Payment ID Nbr
49 RECEIPT_NBR Number(12,0) DECIMAL(12) NOT NULL Receipt Number
50 CHECKLIST_DTTM_VAR DateTime(26) TIMESTAMP Checklist Date Time
51 LOAN_TYPE Character(4) VARCHAR2(4) NOT NULL Loan Type Cd
52 LN_APPL_SEQ Number(2,0) SMALLINT NOT NULL Loan Application Seq Num
53 RESTRICTED_AID_ID Character(10) VARCHAR2(10) NOT NULL Restricted Aid ID
54 AID_YEAR Character(4) VARCHAR2(4) NOT NULL Aid Year
55 CAMPUS_EVENT_NBR Character(9) VARCHAR2(9) NOT NULL Event ID
56 EVENT_MTG_NBR Number(4,0) SMALLINT NOT NULL Event Meeting Nbr
57 APPL_PROG_NBR Number(3,0) SMALLINT NOT NULL Application Program Nbr
58 EFFDT_VAR Date(10) DATE Effective Date
59 EFFSEQ_VAR Number(1,0) SMALLINT NOT NULL Effective Date Sequence #
60 ITEM_TYPE Character(12) VARCHAR2(12) NOT NULL Item Type
61 COMMENT_PRINT_FLAG Character(1) VARCHAR2(1) NOT NULL Print Comments for Communications
62 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
63 COLLECTION_ID Number(12,0) DECIMAL(12) NOT NULL Collection ID
64 EXT_ORG_ID Character(11) VARCHAR2(11) NOT NULL External Org ID
65 ACCOUNT_NBR Character(10) VARCHAR2(10) NOT NULL Account Nbr
66 ACCOUNT_TERM Character(4) VARCHAR2(4) NOT NULL Account Term
67 ITEM_NBR Character(15) VARCHAR2(15) NOT NULL Item Nbr
68 REFUND_NBR Number(12,0) DECIMAL(12) NOT NULL Refund Nbr
69 CONTRACT_NUM Character(25) VARCHAR2(25) NOT NULL Contract Number
70 SESSION_NO Character(11) VARCHAR2(11) NOT NULL Session Nbr
71 GIFT_NO Character(11) VARCHAR2(11) NOT NULL Gift Nbr
72 RECOGNITION_TYPE Character(1) VARCHAR2(1) NOT NULL Recognition Type
73 DESIGNATION Character(11) VARCHAR2(11) NOT NULL Designation
74 INTV_CD Character(10) VARCHAR2(10) NOT NULL Initiative Code
75 AV_AUDIENCE Character(10) VARCHAR2(10) NOT NULL Audience Code
76 AUD_TYPE Character(1) VARCHAR2(1) NOT NULL Indicates whether the population is being identified for Segmentation, Reporting, or Administration.
A=Administrative
R=Reporting
S=Segmentation
77 MEMBERSHIP_NBR Character(12) VARCHAR2(12) NOT NULL Membership Number
78 AV_MBR_ORG_COD Character(10) VARCHAR2(10) NOT NULL Member Organization Code
79 AV_STD_BEN Character(6) VARCHAR2(6) NOT NULL Standard Benefit
80 MBR_PMT_NO Character(11) VARCHAR2(11) NOT NULL Member Payment Number
81 ADM_RECR_CTR Character(4) VARCHAR2(4) NOT NULL Recruiting Center
82 RECRUITING_STATUS Character(4) VARCHAR2(4) NOT NULL Recruiting Status
APPL=Applicant
INAC=Inactive
INQR=Inquiry
PAPL=Pre-Applicant
PROS=Prospect
SUSP=Suspect
83 RECR_STATUS_DT Date(10) DATE Recruiting Status Date
84 APPL_ON_FILE Character(1) VARCHAR2(1) NOT NULL Application on file
N=No
Y=Yes
85 ADM_REFRL_SRCE Character(4) VARCHAR2(4) NOT NULL Referral Source
86 REFERRAL_SOURCE Character(2) VARCHAR2(2) NOT NULL Referral Source
AD=Advertisement
AG=Agency
CL=Client Referral
CO=College Recruiting
CR=College Recommendation
EE=Employee
ES=Employment Securitry Bureau
FE=Former Employee
JF=Job Fair
JP=Job Posting
OH=Open House
OT=Other Source
PI=Phone Inquiry
UK=Unknown
US=Unsolicited
WI=Walk-In
XR=Executive Referral
XS=Executive Search
87 ADM_CREATION_DT Date(10) DATE Admission Data Creation Date
88 COMM_KEY Character(8) VARCHAR2(8) NOT NULL Communication Speed Key
89 COMM_CATEGORY Character(6) VARCHAR2(6) NOT NULL Communication Category
90 COMM_CONTEXT Character(6) VARCHAR2(6) NOT NULL Communication Context
91 COMM_DURATION Number(5,0) INTEGER NOT NULL Recurrence Duration
92 COMM_METHOD Character(1) VARCHAR2(1) NOT NULL Communication Method
B=Publication
D=Document
E=Email
F=Fax
L=Letter
P=Personal Contact
T=Telephone Call
W=Web
93 COMM_DT Date(10) DATE Communication Date
94 COMM_DTTM DateTime(26) TIMESTAMP Communication DateTime
95 COMM_BEGIN_TM Time(15) TIMESTAMP Communication Begin Time
96 COMM_END_TM Time(15) TIMESTAMP Communication End Time
97 DEPTID Character(10) VARCHAR2(10) NOT NULL Department
98 COMM_ID Character(11) VARCHAR2(11) NOT NULL Person responsible for the communication
99 COMPLETED_COMM Character(1) VARCHAR2(1) NOT NULL Communication Completed
100 COMPLETED_ID Character(11) VARCHAR2(11) NOT NULL Completed ID
101 COMPLETED_DT Date(10) DATE Date Activity Completed
102 CHECKLIST_CD Character(6) VARCHAR2(6) NOT NULL Checklist Code
103 RESPONSIBLE_ID Character(11) VARCHAR2(11) NOT NULL Responsible ID
104 RECRUITMENT_CAT Character(4) VARCHAR2(4) NOT NULL Recruitment Category
105 RECRUIT_SUB_CAT Character(4) VARCHAR2(4) NOT NULL Recruitment Sub-Category
HIGH=High
LOW=Low
MED=Medium
106 PROMPT_RECRUITER Character(1) VARCHAR2(1) NOT NULL Use Recruiter Prompt
107 MOVE_TO_APPL Character(1) VARCHAR2(1) NOT NULL Move to Application
108 COMM_COMMENTS Long Character(2000) VARCHAR2(2000) Communication Comments