Special Programs Alberta

Data Dictionary (PSSP ↔ PS SIS ↔ PASI)

<<<<Introduction >>>>>

Document-Level Fields

Field Name

Description

Source System

Target System

Notes

Document ID

Unique identifier for the document

PSSP

PASI

Generated at creation

Document Type

Type of document (IEP, Report, Assessment, etc.)

PSSP

PASI

Controlled vocabulary recommended

File Name

Name of the generated PDF

PSSP

PASI

Should follow naming convention

File Format

Format of the document

PSSP

PASI

Typically PDF

File Size

Size of the document

PSSP

PASI

Optional validation field

Created Date

Date document was created

PSSP

PASI

Auto-generated

Finalized Status

Indicates document is complete

PSSP

PS SIS

Must be TRUE to trigger transfer

Student-Level Fields

Field Name

Description

Source System

Target System

Notes

Student ID

Unique student identifier

PSSP

PASI

Must align with SIS

Alberta Student Number (ASN)

Provincial identifier

PS SIS

PASI

Critical for matching

Student Name

Full name of student

PSSP

PASI

For reference/display

Date of Birth

Student DOB

PSSP

PASI

Validation field

Integration / Transfer Fields

Field Name

Description

Source System

Target System

Notes

Transfer Request ID

Unique ID for transfer request

PSSP

PS SIS

For tracking

Transfer Status

Status of transfer

PS SIS

PSSP

Returned after processing

Transfer Timestamp

Time of transfer

PS SIS

PASI

Audit trail

Confirmation Status

Acknowledgment from PASI

PASI

PS SIS → PSSP

Triggers cleanup

Error Code

Error identifier if transfer fails

PS SIS

PSSP

Needed for troubleshooting

System-Level Fields

Field Name

Description

Source System

Target System

Notes

Tenant ID

Identifies client database

PSSP

PS SIS

Multi-tenant mapping

Plugin Credentials

Auth for Document Attachment

PSSP

PS SIS

Secure exchange

API Endpoint

Integration endpoint

PS SIS

PASI

Abstracted from PSSP

Lifecycle Flags (Future-Ready)

Field Name

Description

Notes

Is Deleted

Indicates document removal

Not yet defined

Version Number

Document version tracking

Needed for updates

Language Code

Language variant of the document

Future multilingual support

Amendment Flag

Indicates modified document

Requires business rules