ADM_TMP3_MC(SQL Table) |
Index Back |
---|---|
ADMA Tmp Data for MCADM_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 |