EMPLIDPrompt Table: PEOPLE_SRCH
1=Yes
2=No
N=No (A)
Y=Yes (A)
Default Value: N
Prompt Table: CAN_PROV_CITZ
Y/N Table Edit
CAN_RPT_STDNT(SQL Table) |
Index Back |
|---|---|
CAN Reporting Fields.* Sac-r75-19990831 |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL |
Employee ID
Prompt Table: PEOPLE_SRCH |
| 2 | CAN_ESIS_SENS_REC | Character(1) | VARCHAR2(1) NOT NULL |
Sac-r75-19990831
1=Yes 2=No N=No (A) Y=Yes (A) Default Value: N |
| 3 | CAN_ESIS_NSN | Character(30) | VARCHAR2(30) NOT NULL | Sac-r75-19990831 |
| 4 | CAN_PROV_FUND_CITZ | Character(6) | VARCHAR2(6) NOT NULL |
Funding Class By Citiz
Sac-r75-19990831: Classifies students by citizenship for grant purposes in accordance with the funding agency's policy. Leave this element blank if your institution does not report this information to the provincial ministry or other agency.
Prompt Table: CAN_PROV_CITZ |
| 5 | CAN_ESIS_APPR | Character(1) | VARCHAR2(1) NOT NULL |
SAC-R75-19990831
Y/N Table Edit |