| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 SSR_SYS_CODE |
Character(4) |
VARCHAR2(4) NOT NULL |
CART system code
|
| 2 |
SSR_CART_REQ_ID |
Number(12,0) |
DECIMAL(12) NOT NULL |
CART request id
Prompt Table:
SSR_CART_SUS_VW
|
| 3 |
SSR_REQUEST_DATE |
Date(10) |
DATE NOT NULL |
CART REQUEST DATE
|
| 4 |
SSR_CART_REF_NBR |
Character(9) |
VARCHAR2(9) NOT NULL |
CART reference nbr
|
| 5 |
SSR_CART_EMPLID |
Character(11) |
VARCHAR2(11) NOT NULL |
CART Empid
Prompt Table:
PEOPLE_SRCH
|
| 6 |
LAST_NAME_SRCH |
Character(30) |
VARCHAR2(30) NOT NULL |
Last Name
|
| 7 |
FIRST_NAME_SRCH |
Character(30) |
VARCHAR2(30) NOT NULL |
First Name
|
| 8 |
SEX |
Character(1) |
VARCHAR2(1) NOT NULL |
Gender
F=Female
M=Male
U=Unknown
X=Indeterminate/Intersex/Unspec
Default Value: U
|
| 9 |
BIRTHDATE |
Date(10) |
DATE |
Date of Birth
|
| 10 |
EDIT_PROC_OPTN |
Character(1) |
VARCHAR2(1) NOT NULL |
Processsing Options
C=Complete
E=Error
P=Perform
|
| 11 |
SRCH_PROC_OPTN |
Character(1) |
VARCHAR2(1) NOT NULL |
Search Match processing option
C=Complete
E=Error
P=Perform
|
| 12 |
SSR_RESULT_OPTN |
Character(1) |
VARCHAR2(1) NOT NULL |
CART result option
A=Awaiting Search/Match
I=Inconsistent Data
M=Multiple Matches
N=No Match Found
V=Verified
|
| 13 |
EMPLID |
Character(11) |
VARCHAR2(11) NOT NULL |
Employee ID
|
| 14 |
SSR_CART_SURNAME |
Character(30) |
VARCHAR2(30) NOT NULL |
CART surname
|
| 15 |
SEARCH_ORDER_NBR |
Number(3,0) |
SMALLINT NOT NULL |
This field identifies the Search Order Number where potential duplicate ID(s) is/are encountered by Search/Match when run as part of a batch process.
|
| 16 |
MATCH_NBR |
Number(6,0) |
INTEGER NOT NULL |
Number of Matches
|
| 17 |
SSR_CART_NBR_RCDS |
Number(7,0) |
INTEGER NOT NULL |
CART nbr of records
|
| 18 |
LAST_NAME_ERROR |
Character(1) |
VARCHAR2(1) NOT NULL |
Last Name Error
Y/N Table Edit
Default Value: N
|
| 19 |
FIRST_NAME_ERROR |
Character(1) |
VARCHAR2(1) NOT NULL |
First Name Error
Y/N Table Edit
Default Value: N
|
| 20 |
BIRTHDATE_ERROR |
Character(1) |
VARCHAR2(1) NOT NULL |
Birthdate Error
Y/N Table Edit
Default Value: N
|
| 21 |
SSR_CART_RRN_ERROR |
Character(1) |
VARCHAR2(1) NOT NULL |
CART RRN Error
|
| 22 |
SSR_CART_SEX_ERROR |
Character(1) |
VARCHAR2(1) NOT NULL |
CART gender error
|
| 23 |
SSR_CART_FNAME |
Character(30) |
VARCHAR2(30) NOT NULL |
CART First name
|
| 24 |
SSR_CART_NAME2 |
Character(30) |
VARCHAR2(30) NOT NULL |
CART Middlename
|
| 25 |
E_ADDR_TYPE |
Character(4) |
VARCHAR2(4) NOT NULL |
Email Address Type.
Note: Dorm long name has been updated as Dormitory as part of PI26 updates. And, the owner id of the field is updated to CC from HR.
BUSN=Business
CAMP=Campus
DORM=Dormitory
HOME=Home
OTHR=Other
|
| 26 |
PHONE_TYPE |
Character(4) |
VARCHAR2(4) NOT NULL |
Phone Type
BUSN=Business
CAMP=Campus
CELL=Mobile
DORM=Dormitory
FAX=FAX
HOME=Home
MAIN=Main
OTR=Other
PGR1=Pager 1
PGR2=Pager 2
TELX=Telex
WORK=Work
|
| 27 |
NAME |
Character(50) |
VARCHAR2(50) NOT NULL |
Name
|
| 28 |
INSTITUTION |
Character(5) |
VARCHAR2(5) NOT NULL |
Academic Institution
|
| 29 |
FILE_PATH |
Character(127) |
VARCHAR2(127) NOT NULL |
Input/Output file path
|
| 30 |
SSR_CENSUS_STRT_DT |
Date(10) |
DATE |
Australia DEST Processing
|
| 31 |
SSR_CENSUS_END_DT |
Date(10) |
DATE |
Australia DEST Processing
|
| 32 |
SSR_RESPONSE_DATE |
Date(10) |
DATE |
CART REQUEST DATE
|
| 33 |
SSR_ENRL_MTCH_RES |
Character(3) |
VARCHAR2(3) NOT NULL |
Enrolment Match Result
|
| 34 |
SSR_REQ_DATETIME |
DateTime(26) |
TIMESTAMP |
CART REQUEST DATE
|